I'm trying to run a macro.
The data can change in row length from spreadsheet to spreadsheet.
I want to find the end of the data (i.e row 20 or row 1000)
and in the next row set up various arrays.

Obviously the 'shft' + 'ctrl' down arrow takes me to the end bottom of the
data, but the macro then sets absolute address so the next spreadsheet gets
the wrong parameters.

Any ideas?

Thanks