LinkBack URL
About LinkBacks
:This is my code where I want to paste data into cells that are hidden in the workbook but its not workingAny help appreciated
Please Login or Register to view this content.
:This is my code where I want to paste data into cells that are hidden in the workbook but its not workingAny help appreciatedPlease Login or Register to view this content.
How about just setting the values equal directly:
Please Login or Register to view this content.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
Its giving me subscript out of range. I have had to change the code slighThe other thing is its opening the workbook, then telling me the workbook is already open and do i want to reopen? Any ideas?Please Login or Register to view this content.
Ok I sorted this out by chaging the code above slightly to:
But i've got another issue so i'm gonna post in a new threadPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks