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" <(E-Mail Removed)> wrote in message
news6q9ejbkeevb.15k1udu8uaqbl$.(E-Mail Removed)...
> 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