hi there
I'm trying with coming up with VBA to select the last range
I googled and this selects all ranges starting from A2
The problem is I need that A2 to change dynamically.
hope my explanation is ok
james
I'm trying with coming up with VBA to select the last range
![WKRNeoy.png](/board/proxy.php?image=https%3A%2F%2Fi.imgur.com%2FWKRNeoy.png&hash=d9214bcdf13bc8502d635688b84901d5)
I googled and this selects all ranges starting from A2
Code:
Range("A2:F" & ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row).Select
hope my explanation is ok
james