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