Suppose:

[A2] = [A1]

would do?!

J

"CalumMurdo Kennedy" wrote in message ...
Thanks Guys,

It's funny how i manage to avoid the easiest way of doing things!

Best Regards,

CalumMurdo Kennedy
www.taekwondo.freeserve.co.uk

"Don Wiss" wrote in message
...
On Sun, 12 Oct 2003, CalumMurdo Kennedy wrote:

I have this at present (which pretty much came from the macro recorder):

Range("A1").Copy
Range("A2").PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False

Tom's response is the correct solution. But when you do need PasteSpecial
you can simply the above to:

Range("A1").Copy
Range("A2").PasteSpecial Paste:=xlValues

Don <donwiss at panix.com.