Max number of rows and columns

  • Thread starter Thread starter Corey Bennett
  • Start date Start date
C

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
 
Hi Corey,

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

Second line frees up the entire sheet.

HTH
Regards,
Howard
 
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.
 
Back
Top