I have a range of Excel cells of which the first row is the header. There are several more rows with the actual data. There can be variable number of rows.
What is the best way to select this whole range of Excel data when you don’t know how many rows and columns it contains? If I use Read Range or Select Range I will have to specify the range itself e.g. A1:?? but in this case I don’t know the location of the bottom right cell.
Preferably, I should be able to do this just by selecting the top left cell. I want to be able to do this without formatting the range as a ‘table’ or making changes to the Excel file itself.