Row & Colomns

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

you could set row heights beyond 101 to 0 and column widths beyond Col
T to 0, but why not hide them??
OJ

Private Sub Worksheet_Activate()
Columns("U:IV").Hidden = True
Rows("101:65536").Hidden = True
End Sub


--
----------------------------
Mauro Gamberini
"Khalil Handal" <[email protected]> ha scritto nel messaggio
news:[email protected]...
> 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
>
>
>

In article <[email protected]>,
"Khalil Handal" <[email protected]> wrote:

> Note:
> I don't want to use "hide" option for row and colomns. Is this possible?

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.



"Khalil Handal" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
>

Hi,
I ewent to the VB editor [Worksheet active]
pasted te code. Nohing happend!!!!!!!
I don't know if I miss something?

Khalil