You will need a .Copy then a .PasteSpecial.

Or:
Range("B1").Value=Range("A1").Value

NickHK

"Damien McBain" wrote in message
...
I'm using:

blah.Copy Destination:= etc

Is there a way I can copy the values only and not the formatting? The VBA
help is not forthcoming.

TIA

Damo