View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ben Ben is offline
external usenet poster
 
Posts: 509
Default 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.