limit number of rows & colums in a worksheet

[davidbrowne17]

is there a way to limit the number of available colums & rows in a
particular worksheet.

 

[Chip Pearson]

David,

You can hide all the unused rows and columns, or you could set
the ScrollArea property to a specific range address.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Paul]

is there a way to limit the number of available colums & rows in a
particular worksheet.

Please don't send multiple posts. See my answer to your previous post.

 

[Jim]

There are always 256 columns and 65536 rows in every worksheet. You may
select unwanted rows and hide them; you may also set the scroll area in VBE
This Workbook object:

Workbook_Open
Private Sub Workbook_Open()
Worksheets(1).ScrollArea = "A1:R10"

End Sub