G
Guest
I have a macro which imports a .htm file from another application then sorts the rows,
The problem is that the number of rows in the import file varies. In writing the macro I use ctrl downarrow to select the last cell in the column, select that cell - scroll to the top select the range. Even though I used ctrl keys to select the range Excel takes the values as absolute
How can I make the Range selection relative. First cell to last cell regardless of the length of the file
The problem is that the number of rows in the import file varies. In writing the macro I use ctrl downarrow to select the last cell in the column, select that cell - scroll to the top select the range. Even though I used ctrl keys to select the range Excel takes the values as absolute
How can I make the Range selection relative. First cell to last cell regardless of the length of the file