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

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

NickHK wrote:

You will need a .Copy then a .PasteSpecial.

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


Thanks Nick, I am trying to avoid using the clipboard. I should be able to
make "a.value = b.value work".

cheers

Damien