Hi,
AM having an error "subscript out of Range (Run time error 9)" in this macro
I highlighted a line, where i get this error.Please Login or Register to view this content.
Please help
Thanks
Hi,
AM having an error "subscript out of Range (Run time error 9)" in this macro
I highlighted a line, where i get this error.Please Login or Register to view this content.
Please help
Thanks
Last edited by shiva_reshs; 07-05-2013 at 02:32 PM.
Try this
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi, shiva_reshs,
GetOpenFilename gives you the path and the name of the file to open but it doesn´t open the file. So you would to do that prior to activating.
Instead of
you should rather usePlease Login or Register to view this content.
Ciao,Please Login or Register to view this content.
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
Try this.
Please Login or Register to view this content.
Last edited by Norie; 07-06-2013 at 10:32 PM.
If posting code please use code tags, see here.
Thanks.. Both method works
One small tricks needed though..
When I choose the file, destination file has 3 sheets and i want the data to be copied from sheet3. But the code picks up sheet1 data. Any help??
Thanks
Simple - change Sheet1 in this line to Sheet3 -Please Login or Register to view this content.
sorry. it works perfectly.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks