Using VBA to Paste items copied within Excel
is the cell you are trying to paste into either merged wiht other cells or
Locked? That would cause that error
"ExcelPeter218" wrote:
I copy cells from a row in Excel and position the cellpointer at the
destination cell.
I then activate the macro recorder and record a single paste command and
stop the macro recorder.
When I attempt to use this macro I get 'Run time error 1004'.
I am using Excel 2002 and Windows XP.
THis works with Excel 97 and Windows 98.
What did I do wrong or forget to do?
Thank you for your help in advance.
|