I didn't say manual. I said manual. So, I guess it depends on what your
definition of is is....

I didn't mean to read a manual. I meant to do it manually. The dialog box
will not show that option.

--
Don Guillett
SalesAid Software

"Chris" wrote in message
...
Thanks I'll try this, don't have a manual hence my problem

Chris

"Don Guillett" wrote:

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