Writing a macro to copy first cell down until next cell has data
 

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!

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!