Error in Paste Macro
Posted by Laurie M. on August 16, 2001 2:58 PM
I created a copy macro to copy a sheet into another file as well as a paste macro to paste that sheet. The copy macro works, but I get an error with the paste macro "Run time error 40036. Application defined or object-defined error. Microsoft suggested that there is a blank macro, but I don't know how to delete a blank macro that I can't see. Any advice?
Posted by neo on August 17, 2001 7:48 AM
if what ms suggested is right, you just have to go into your VBE and delete the empty modules in the project explorer. or try manually cutting and pasting the data, including just the code for your copy and paste functions, into a new workbook and resaving it. if that doesn't work, it's likely something in the code your macros use, but unless i see that there's nothing i can do there...
good luck
neo
