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

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