Row & Colomns

  • Thread starter Thread starter OJ
  • Start date Start date
O

OJ

you could set row heights beyond 101 to 0 and column widths beyond Col
T to 0, but why not hide them??
OJ
 
Hi,
I need ONE worksheet with 100 rows & 20 colomns only.
Is there a way to have this?

Note:
I don't want to use "hide" option for row and colomns. Is this possible?
Khalil Handal
 
Private Sub Worksheet_Activate()
Columns("U:IV").Hidden = True
Rows("101:65536").Hidden = True
End Sub
 
Khalil Handal said:
Note:
I don't want to use "hide" option for row and colomns. Is this possible?
Click to expand...

No. All XL worksheets have 65536 rows and 256 columns.
 
Yes, you can have this:

Go intio the VB environment (Alt-F11)
In the properties for the sheet, you will find listed: "Scroll Area", which
will be blank.
Set this scroll area to the area you want available in the worksheet, ie
A1:T100

(don't use speechmarks"")

You may still see the other columns/rows, but you can shade them before you
perform this operation.
 
Hi,
I ewent to the VB editor [Worksheet active]
pasted te code. Nohing happend!!!!!!!
I don't know if I miss something?

Khalil
 
Back
Top