My attached spread sheet has a macro that copies the line highlighted to the archive sheet and then deletes that line from the active sheet the macro is activated by hitting the button at the top left of any of the department sheets.
The macro worked fine until the end of our fiscal year when I removed all the archived work orders from the archive page, to start the year new.
Now when I try to archive something from one of the department sheets, it copies it to archive and gives me a range error.
Up until now there has always been information on the archive sheet, I'm not sure if removing all the information on that sheet caused the macro to stop working properly.
Could someone please look at the macro set up and tell me if I am doing something wrong?
I'd be happy to send the last working file upon request. (the file that has all the information in the archive section and was running the macro correctly)
Thanks in advance.
Bookmarks