You could do it twice

somerange.pastespecial paste:=xlpasteformulas
somerange.pastespecial paste:=xlpasteFormats

One right after the other.

You didn't really mean values, right?




Chris wrote:

Hi everyone - hope you can help

Is there any way to tweak the code to paste Values and Formulas and thats
all

can't get the code to allow multiple criteria, I don't want the formatting
just the values and formulas

PasteSpecial Paste:=xlPasteFormulasAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False

--

Dave Peterson