I'm trying to write a macro for formatting a .txt file into an Excel
spreadsheet. It's different everymonth. I can get all the keystrokes recorded
correctly except for the following:

Let's say a portion of the macro takes me to cell A1681, I would then like
to highlight that row and all the rows above it (Ctrl+Shift+Home). However,
it only references the count of rows between that and row 1, which will vary
each time. Is there a code for this. Also, the opposite, if I'd rather
highlight row A1681 and all the rows to the bottom of the spreadsheet.

Any help is much appreciated. Thanks!