How to make data sets to by dynamic in VBA

[Hwaijontan]

Hi,

Wanted to ask how to enable my datasets within VBA to be dynamic for future VBA purposes ?
In my "Record Macro" function, I selected the available range of data (Ctrl + Select + 8), but within the VBA, the code specifies the range which I did in my initial loop.
How to allow my future VBA when activated will select the range of data (as it grows) to allow all the datasets, including the new one will be included in the macro function ?

Thanks

 

[mohadin]

Example:

With ActiveSheet
Lr = .Cells(.Rows.Count, "A").End(xlUp).Row
Cells(1,1).Resize(lr)

End With