hI JEN,

Just +1 to lastrow ... maybe helpfull for you ...

Thanks,

Halim

Jentan menuliskan:
Hi,

I think there isn't any problem with the copy paste formula. I have
used the same logic for others. The logic is as below.

Range("A1:E1").copy range("A2")

Appreciate if you can assist to list down the correct formulaes.

Thank you.


Simon Lloyd wrote:
without using your code i notice that in your IF THEN statement you
specify a range to copy and directly after specify a destination but no
selection or paste command.

Regards,
Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=572036