Brian Matlack wrote:
Hello again!!
I know this is simple but no one ever said I was the sharpest knife in
the drawer. When this code pastes to location I want values not
formulas. How can I do this?


you need to use

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

hope this helps

AR