LinkBack URL
About LinkBacks
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by cdjones; 09-22-2010 at 06:25 PM.
What's the code supposed to do?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Code is supposed to open a workbook, and then select some cells for copying.
The workbook opens, but I get error 1004 when I try the selection.
Try:
Please Login or Register to view this content.
Remember what the dormouse said
Feed your head
Romper, aside from making the implicit explicit, I'm missing why that would fix whatever's wrong.
The code would certainly fail if the active sheet were not a worksheet, but I can see little else. What am I missing?
Entia non sunt multiplicanda sine necessitate
If that code is in a worksheet code module, then the two Cells calls would refer to that sheet, not to the active sheet, and cause an RTE.
Working, thanks
Doh !If that code is in a worksheet code module
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks