Max number of rows and columns

[Corey Bennett]

Hi,
Does anyone know how to set the maximum number of rows and columns on a
worksheet so that it will not scroll past say 20 rows and 10 columns?

thanks

Corey

 

[L. Howard Kittle]

Hi Corey,

Sub S_A()
ScrollArea = "a1:j20"
'ScrollArea = ""
End Sub

Second line frees up the entire sheet.

HTH
Regards,
Howard

 

[Dave Peterson]

And that's one of those properties that isn't remembered when you close the
workbook and reopen it.

You might want to put it in your auto_open or workbook_open code.