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!