Apologies for not being so clear, If I am correct the above line is copying the data within the given range from active sheet to Wb1 sheet.
When I ran the macro, It is copying the sheet1 data range on Sheet2. but what I am looking for is to pull the data from different excel file (here the Source sheet name varies everytime) on Sheet2 of the open file.
Many thanks,
Omer
Hi, momer,
you should make clear if Sheet2 is the name displayed on the worksheet tab or the codename for the sheet In your code you have both used Worksheets(2) which would mean the second worksheet in the collection of worksheets as well as Worksheets("Sheet2"). So you could replace
by
ThisWorkbook.Sheets(strSheetName)
Ciao,ThisWorkbook.Sheets("Sheet2")
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks