VBA, How to make data dynamic growing along with another sheet
 

Hi
How to program/name so that data growing along with other sheet. For example
the "date" column with grow with "date" column at other worksheet?
Thanks
Daniel

VBA, How to make data dynamic growing along with another sheet
 

Let's say the date column is in Column A.

Dim myRange as range
Dim lRow as long
Dim aWS as worksheet
set aWS = activesheet 'Change as needed
set myrange = aws.range("A1") 'Change as needed
lRow = aws.cells(aws.rows.count, myrange.column).end(xlup).row
set myRange = myrange.resize(lrow - myrange.row + 1, 0)

--
HTH,
Barb Reinhardt



"Daniel" wrote:

Hi
How to program/name so that data growing along with other sheet. For example
the "date" column with grow with "date" column at other worksheet?
Thanks
Daniel