Hi Andreas

You can use code from this page to find the lasr row with data
http://www.rondebruin.nl/last.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Andreas" wrote in message ...
Another issue as well... I want to create a button that automatically copy an
area from 5 different sheets and put them into a new sheet. Not that complex,
but the problem is that the number of rows included when copying might differ
from time to time so I cannot just create a macro to paste in the second area
below the first one as I do not know how many rows the first one will have
next time. Anyone know the VBA to do this?

Thanks