Have a look at a manual copy/paste in xl97 and you will see that this is not
an option in xl97. So, try pasting values and then pasting formats.

..PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
..PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:= _
--
Don Guillett
SalesAid Software

"Chris" wrote in message
...
I have the the following error in Excel 97 (below) when running a macro
created in Version 2002. The code line is

Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False,
Transpose:=False

Error
Runtime error 1004 PasteSpecial method of range class failed

Can you help on this and tell me what needs to be changed in the line of
code
above. The code is doing a past special of values and number formats ony

Cheers
Chris