View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Writing a macro to copy first cell down until next cell has data

Use this Gerald
http://www.contextures.com/xlDataEntry02.html


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Gerald" wrote in message oups.com...
I need help writing a macro to take the first cell in a particular
column that is not blank and copy it down until the next cell tha does
have data and keep doing so until the end of the spreadsheet. Any help
would be appreciated.

Thanks!