Macro - Run Time Error '1004'
Posted by Renee' on August 15, 2001 5:47 AM
We are working on an existing file with Macros that someone else has set up. We are trying to add information to the file and when we try to run a Macro, we are getting the following error "Run Time Error '1004' PasteSpecial method of Range class failed". When we choose 'debug', it goes to the following line in the Macro:
Selection.PasteSpecial Paste:=x1Values, Operation:=x1Add, SkipBlanks:= _ True, Transpose:=False
We are just learning about Macros and I'm not sure how to figure out what it doesn't like here. Any advice would be helpful! THANKS!!!!!!!!!