Im using this bit of code which I thought would select Column A to FF and go to the last row containing data in this range.
Dim r As Long
r = Range(Selection, Selection.End(xlDown)).Row
Range("A" & Selection.Row, "FF" & r).Select
It is only selecting the first row for some reason and Im not sure what the issue is.
Would you be able to help me on this?
The attached example should result in the range A1:FF31 being selected when the code is run but unfortunately, im missing something ..