I have a macro which copy text from a sheet (sheet-1) and paste it into another sheet.
I want sheet-1 to be hidden, or even better, very-hidden, but when I hide sheet-1 the macro run fails. Respons Run-time error '1004'...
Is it a solution around this 'problem' or does sheet-1 always has to be visible ?
Last edited by Saturn; 02-14-2014 at 08:00 AM.
The macro probably uses range.select to perform copy/paste which is completely unnecessary.. You can copy data from a very hidden sheet.
This would suffice
Please Login or Register to view this content.
Last edited by AndyLitch; 02-14-2014 at 06:37 AM.
Elegant Simplicity............. Not Always
Great!
Sheet-1 become sheet-2 and vv. so after this correction it works!
glad to hear it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks