Putting formula in max value of scroll bar format

[spaceknight]

I want to put the formula COUNTA($D:$D) in the maximum value of the scroll bar so that I can have the scroll bar ranges match my dyanamic range data. Is this possible with or without VBA? I'm not very familiar with VBA if it is necessary so if someone could explain that would be very helpful, thanks.

[AndyLitch]

The syntax depends on the type of scroll bar you are using... If it's an ActiveX scrollbar you can set the Max property using Sheet1.Scrollbar1.Max = Max(D1:D50000)