Hi Bernie, many thanks for your very usefull help
Valdemar

Bernie Deitrick pÃ*Å¡e:

Valdemar,

ActiveSheet.Cells(Rows.Count,1).End(xlUp)(2).Selec t

will select the first empty cell at the bottom of column A.

HTH,
Bernie
MS Excel MVP


"Valdemar" wrote in message
...
Hi all,
please help. I have to add every day new data (number of rows is various) to
existing data sheet. I suppose to use macro and run that automatically at
night. As I have to add it to table where number of rows will groe up, I need
to start copying new data to the first blank cell in the first column. How
can I force macro to find this blank cell when the position will shift?
Many thanks,
Valdemar


.