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