Search results

Hi Smallman, I tried to understand this code and got to know that you have used Array in coding. Although I do little bit of VBA but I really don't understand how Array works. In the code you sent, I understood everything except one i.e Sheet2.Range("A" & Rows.Count).End(xlUp)(2) = ar(i, 1)...

Hi, This is not coded by me, but found it to be very useful. Hence attaching for you. With Regards Rudra

Hi Smallman, This worked perfectly fine, thank you very much for your patience and help. You have saved my hours of time. Do take care. With Regards Rudra

Hi, I think you don't have select "Summary" Sheet to print it. instead , why not use set MySheet = Sheets("Summary") FName = MySheet.Range("D1").value With MySheet .ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "\\SERVER-NATBIO\Distribution\LOG\Uncontrolled\" & fName...

Hi Dandapani, I also use almost similar function. Here is mine [code = vb] Function AgingBucket(Age As Integer) As String If Age >= 120 Then AgingBucket = "120 Days" ElseIf Age >= 90 Then AgingBucket = "90 Days" ElseIf Age >= 60 Then AgingBucket = "60 Days" ElseIf Age >= 30 Then AgingBucket...

Hi, Here is my full client list With Regards Rudra

Hi Friend, Thank you very much for your reply. I have not made any error on listing files. Col A files are master files(position shouldn't be changed). Files in Range B2:B4 are supporting files for Master File(A2) (these files should be listed across master file).Like wise Files in Range B5:B7...

Hi All, I need a help. I have an excel file where in Col A File names are listed and in col B Full File Path & Names are listed. What I want to do is Col A should remain as it is but contents of Col B should be arranged in such a way that they get listed across. I don't think I will be able to...

Hi Peter, Thank you very much for your prompt reply. Thanks a lot.

Hi Awesome guys, I have developed a pivot table, which is attached herewith. In this PT I want to highlight different years in different colors. Is there any easier way to do this? I know how to do it manually but I am looking for VBA solution. I tried doing with for next loop but it didn't...

Hi All, How to change the author name in excel files with VBA?

Hi All, I have a problem in VBA. I have Reports called 'Masters' in one folder and reports called 'CAR' in another. My problem is I need to open both the files from these two different path and work and close them. Next it has to open 2nd master file and 2nd CAR file and so on. I tried with...