Hi Martin

You can use end down or end up to go to the last row. With end up you
actually go to the last row in the sheet, and then end up to the last used
row.

"Martin Hextall" wrote:

I have written a macro to get data from several spreadsheets and paste it
into another. Because the size of the data is variable, I am having to leave
spaces between sections of data to ensure that it doesn't overwrite anything.
Is there a way that the macro can look for the next empty row rather than me
leaving gaps?