I have a new problem with the same code so have started a new thread. (Hope this is O.K. moderators?)
My code is conditionally opening spreadsheets in a folder, pulling information from certain cells and putting them in a master spreadsheet.
When it comes across a spreadsheet that has been digitally signed I get the error message-
Copy method of range class failed
The debugger points at this line:![]()
Please Login or Register to view this content.
Cell.Copy DstRng.Offset(LR, C)
Is there a way to stop this happening?
Bookmarks