how to determine the size of the sheet

[Harald Staff]

Hi Ahmed

The number of rows and columns are fixed. Your workaround would be to hide
the ones you consider unneeded.

HTH. Best wishes Harald

 

[Ahmed SHEBL]

Hi

I had a collegue who told me once a way to dtermine the number of the rows
in a sheet of the workbook I am working at.
It is known that when you open a new workbook each sheet has maybe 65365 or
something like that rows.

MY QUESTION IS: HOW TO MAKE THE SHEET 1000 ROWS OR WHATEVER NUMBERS OF
ROWS I ONLY NEED?

Thanks in Advance,

Ahmed

 

[Bob Umlas]

Hey, Harald -- how are you? You were/are missed! Hope things are well.
Bob Umlas

 

[Harald Staff]

Things are well, Bob, thank you. I spend far too little time here and I
really miss you guys.

Best wishes Harald

 

[Gord Dibben]

Good to see you're still around.

Gord

Things are well, Bob, thank you. I spend far too little time here and I
really miss you guys.

Best wishes Harald

 

[Dave Peterson]

Nope. There's no way to reduce the number of rows or columns in a worksheet.

You can hide them like the prodigal son Harald suggested or you could actually
use some code that won't let the user scroll too far right or too far down. But
that requires a macro.

If you want to try that:

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.ScrollArea = .Range("a1:f22").Address
End With
End Sub

Excel won't remember these settings after you close it and reopen the workbook
(that's why it's in auto_open).

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

=====
Personally, seeing all those columns doesn't bother me. I don't think it
bothers most excel users either. And if you're new to excel, then give it some
time and it won't bother you either <bg>.

 

[Ahmed SHEBL]

Hi Harald,

as I said in my first posting, I had a colleague who did that before in a
prior job. and I left that place and worked for another place. I am sure he
did it.

There must be another way to work around that Harald. do u think you can
help me on that

by the way, I can see you met an old friend of your through my post. you owe
me one ;-)

Many thanks,
Ahmed