Hi,
I want to archive results from one spreadsheet to another. I have a macro button to do this (code from a colleague below) and it works when I use it initially. However, if I run the macro again it then fails on the line in bold. I'm not sure why this would be. I have tried stepping through the code and it seems to select the right cell but won't paste.
Any ideas would be appreciated.
Many Thanks,
Zoe
Please Login or Register to view this content.
Bookmarks