cRows = Cells(Rows.Count,"A").End(xlUp).Row

so the next free nrow would be cRows+1

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Acid-Sky" wrote in
message ...

Hi,

I think I understand your answer and it is perfect for using the cells,
but it is not exactly what I am trying to do. Furthermore it doesn't
take into account that I just don't know how many rows there are (as
their numbe ris dynamic). Could be 10 rows or 20.000...

And how can I use this in VBA?

Thanks :)


--
Acid-Sky
------------------------------------------------------------------------
Acid-Sky's Profile:
http://www.excelforum.com/member.php...o&userid=26502
View this thread: http://www.excelforum.com/showthread...hreadid=397715