limit number of rows 7 colloms in a worksheet

[davidbrowne17]

is there a way to limit or set the number of rows & collums in a
worksheet ?

thanks

david

 

[Paul]

is there a way to limit or set the number of rows & collums in a
worksheet ?

No. All worksheets have 256 columns by 65536 rows.
You can hide unused rows/columns. But why bother?

 

[L. Howard Kittle]

Hi David,

Put this in the ThisWorkbook code module. Adjust to suit the area.

Private Sub Workbook_Open()
Worksheets(1).ScrollArea = "A1:F10"
'To restore
'Worksheets(1).ScrollArea = ""
End Sub

HTH
Regards,
Howard