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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

No row or colomns a visibale 5
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Excel Complex Summing 3
Unused colomn / Rows 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
countif quary 1
Print macro that hides rows before printing 1

Back
Top