In Excel, the keystrokes Shift+End+Arrow(any direction) selects the data from
the cell where the keystroke was invoked to the end of the data (in whichever
direction was indicated).
I used these keystrokes to create a macro to select data in a particular
column. It worked fine on my test file. However, if I use that same macro on
a file with a different number of data rows, the macro does not make the
selection in the same manner.
Whatever cells were selected on the recording is what is included in the
macro coding. Is there a way to edit the macro where it will mimic the
Shift+End+Arrow keystrokes? I want to select the data in a column, not a
specific hard-coded cell range.