Hi all
I have used code:
max_people = Application.WorksheetFunction.CountA(Worksheets("PEOPLE").Range("D:D"), 0) - 2
to get the total number of people in sheet people then ried this code to limit the scroll area:
Worksheets(i).ScrollArea = ("C4:AZ & (max_people)+2")
and is'nt working.
Also how can be set this range to hide automatically all rows from range max_people to 65536?
Cheers all.