Range("A1").End(xlDown).value = range("B1").value

HTH

--
AP

"elrussell" a écrit
dans le message de
...

Hi - I need a macro to copy the plain text value in B1 to the first
empty cell in column A. Any help will be greatly appreciated.
Thanks.


--
elrussell
------------------------------------------------------------------------
elrussell's Profile:
http://www.excelforum.com/member.php...o&userid=31020
View this thread: http://www.excelforum.com/showthread...hreadid=518125