Hi,
I had the following code which was working when I was under Windows XP. After converting to Windows 2007, I tried running the same macro to no avail. Run-time error 1004 would pop up. The debugger would highlight the Copy Before action. Any advice is greatly appreciated!
Thank you!
Please Login or Register to view this content.
Is this macro using more than one workbook? It doesn't seem to be. So why are you setting and activating this workbook?
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Maybe try this:
abousettaPlease Login or Register to view this content.
Hi abousetta,
Thank you for the quick reply, I will try this tomorrow when I am back at work. The code is basically trying to copy from the main workbook to generate multiple workbooks (one per region based on a region column identifier). I am not well-versed with VB and I'm sure there's a much cleaner way to get the result (your suggestion definitely looks neater). At the time when I was in Windows XP, the original code did work, but for some reason after converting to Windows 7, it went wonky.
Much appreciated! I will follow-up tomorrow.
Good morning,
Inputting the above code gets me a new error - Run-time error 9 (Subscript out of range). Debugging highlights the following:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks