is there a way to limit the number of available colums & rows in a particular worksheet.
D davidbrowne17 Dec 11, 2003 #1 is there a way to limit the number of available colums & rows in a particular worksheet.
C Chip Pearson Dec 11, 2003 #2 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
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
P Paul Dec 11, 2003 #3 davidbrowne17 said: is there a way to limit the number of available colums & rows in a particular worksheet. Click to expand... Please don't send multiple posts. See my answer to your previous post.
davidbrowne17 said: is there a way to limit the number of available colums & rows in a particular worksheet. Click to expand... Please don't send multiple posts. See my answer to your previous post.
J Jim Dec 11, 2003 #4 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
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
