I created a macro that formats a report in one workbook and then opens another file macro_prep.xls. It then copies a range and should go back into the first workbook. However, when I run the macro it just copies the data and pastes it back into the Macro_Prep.xls. I believe my problem lies somewhere in the thisworkbook.activate line but am not sure. Any insight as to why this is happening would be greatly appreciated.
Please Login or Register to view this content.
Hi jortarr;
Not positive but try this:
Please Login or Register to view this content.
You'd better write in plain English what you want to accomplish with this macro (illustrated by a dummy example).
Then you'll receive a 'solution' macro with 5 codelines that persorms what you want.
E.g the code
can be replaced byPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by snb; 07-02-2010 at 04:48 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks