I set my macro up to run on multiple spreadsheets. Unfortunately, the macro
functions are performed for the number of lines in the original spreadsheet.
The macro was recorded using 'ctrl + end' rather than a specific row and
column.

Is there a way to have the macro only apply through 'ctrl + end' ?
Thanks.