I want to copy a range from Excel where I know the starting point (cell A5) but I don’t know the end row because this might change everytime the data is downloaded from the system. What do I write into the “Range” properties?
I tried - as suggested in another thread here - “A5:AA”+lastRowIndex.toString. For this I get the error that lastRowIndex is not declared.
Can anybody help?
Thx in advance