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.
Everyone who confuses correlation and causation ends up dead.
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)
Bookmarks