is there a way to limit or set the number of rows & collums in a worksheet ? thanks david
D davidbrowne17 Dec 11, 2003 #1 is there a way to limit or set the number of rows & collums in a worksheet ? thanks david
P Paul Dec 11, 2003 #2 davidbrowne17 said: is there a way to limit or set the number of rows & collums in a worksheet ? Click to expand... No. All worksheets have 256 columns by 65536 rows. You can hide unused rows/columns. But why bother?
davidbrowne17 said: is there a way to limit or set the number of rows & collums in a worksheet ? Click to expand... No. All worksheets have 256 columns by 65536 rows. You can hide unused rows/columns. But why bother?
L L. Howard Kittle Dec 12, 2003 #3 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
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
