If you want it to be at 4 times slower than

Range("A2").Value = Range("A1").Value

and only need to deal with a hardcoded range.

--
Regards,
Tom Ogilvy

"jason" wrote in message
om...
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.