Paste Special problem

[Craig1]

Hi All,
Can paste special in VBA just paste the formulas instead of the values.
I use the VBA below in a workbook but in another workbook I need to paste formulas only.

Selection.PasteSpecial Paste:=xlPasteValues

I did try this, but for some reason it fails

Selection.PasteSpecial Paste:=xlPasteFormulas

Any help would be appreciated.
Craig

 

[VoG]

That should work. In what way does it fail?

 

[Craig1]

Thanks for the reply Peter, I had a typing error in there.

Craig.