Thread: copy cell
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default copy cell

Ooops!
Range("A1").End(xlDown).offset(1,0).value = range("B1").value

--
AP

"Ardus Petus" a écrit dans le message de
...
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