How can I get the code below to paste formulas and formats
as well as values?


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

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

--
Regards,
Tom Ogilvy

"shawn" wrote in message
...
How can I get the code below to paste formulas and formats
as well as values?


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

Shawn,

Change your Paste:=xlValues to Paste:=xlPasteAll

Look in the Microsoft Excel Visual Basic help for the
pastespecial method for all of the valid options for
pastespecial.

Sincerely,

Kris

-----Original Message-----
How can I get the code below to paste formulas and
formats
as well as values?


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


.