Using VBA to Paste items copied within Excel

[Guest]

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.

 

[Guest]

is the cell you are trying to paste into either merged wiht other cells or
Locked? That would cause that error

 

[Guest]

You are calling Excel to paste only, not what it is suppose to paste, so of
course you are going to get a run time error as it has no idea what data is
to be pasted. If you want the macro to work, you record before copying the
cells. If you want a different functionality, please specify.

Kou

 

[Guest]

Re:Reply to My Pasting Problem

Thank you for taking the time to help.
The macro I am trying to run is as follows:
Sub TransposeValuesOnly()

Attribute TransposeValuesOnly.VB_ProcData.VB_Invoke_Func = " \n14"
'
' TransposeValuesOnly Macro
' Macro recorded 3/13/2003
'

'
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True
Selection.End(xlToRight).Select
End Sub

This macro was created using the macro recorder and has worked fine for over
a year.

Using Windows ME and Excel 2000 I copy a column of cells, position the
cellpointer
at the first cell of the destination and then run the above macro. The
column of
cells are transposed into the destination row and the cellpointer is
positioned at the
end of the pasted cells.

Now that I have changed to Excel 2002 I get the 1004 error, with the same
Macro.

I want VBA to paste date that has been copied to the clipboard in Excel, why
doesn't
VBA know that it is there.

Thank again.