Number of rows and columns

[AC]

Hi,
I have a spreadsheet that has only 85 rows and columns to AH. After
that the spreadsheet is gray. I checked, but there are no hidden rows
and the VBA code does not have anything apparent to hide or limit the
rows/columns. Could somebody explain how that is done?

Thanks in advance.
BR,
A. Crawford

 

[Sandy]

You are in page break preview, click on the view drop down and select
normal to see the whole speardsheet


Sandy

 

[AC]

Sandy,
I forgot to mention in my post that I am in normal view. I have also
cleared all print areas.

Any other suggestions?

TIA.
BR,
Antje Crawford

 

[Sandy]

Do me a favor place the below in a macro and run it and let me know
what number comes back in the message box...

Sub Page_View_Test()
MsgBox ActiveWindow.View
End Sub


make sure your problem window is active (not in the backround)
-press ctrl +F11 (opens the visual basic editor)
-click on Insert ===> Module
-Paste the code
-close the editor

-In excel click on Tools ==> Macro ==> Macros...
-Click on Page_View_Test and click run

Sandy

 

[AC]

Sandy,
msgox returns 1.

Thanks.
Antje

 

[AC]

Sandy,
msgbox returns 1. What does that mean?

Thanks.
Antje

 

[Sandy]

It means that you are in normal view, if it was a 2 it would have meant
that you were in page break preview view
A couple of questions

1) In the workbook are all the worksheets like this or only this one
sheet
2) are there blue lines bordering the worksheet
3) does this happen in a new workbook

Sandy

 

[Sandy]

Also check to see if there are any custom views set up in the worksheet
under the view drop down

 

[AC]

Sandy,
1. All worksheets in this particular file are that way.
2. There are no blue lines bordering the worksheet.
3. When I open/create a new workbook this does not occur, meaning I
have my 65536 rows and 255 columns.

No, there are no custom views set up.

Also, the gray area does not even have column & row headings.

Any thoughts?

Thanks for your help.
BR,
Antje

 

[Sandy]

ok found the problem you do have hidden rows and columns the easiest
way to unhide them is run this code in the same module that you ran the
last one

Sub unhiderowscolumns()
ActiveSheet.Columns.Hidden = False
ActiveSheet.Rows.Hidden = False
End Sub

Sandy

 

[AC]

Sandy,
Thank you very much. That did the trick. Can you tell, just by what
little information we have exchanged, how the rows/columns were hidden,
e.g. by code or manually?

Thanks again.
Antje

 

[RagDyeR]

Can be done either way.

To try it manually, take a new sheet and select say *all* of Column D by
clicking in the header.

Then:
<Ctrl> <Shift> <Right Arrow>
Right click in the selection and choose "Hide".

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Sandy,
Thank you very much. That did the trick. Can you tell, just by what
little information we have exchanged, how the rows/columns were hidden,
e.g. by code or manually?

Thanks again.
Antje

 

[Sandy]

My guess is manual...Unless someone coded into vba played the macro and
then erased the code (which would take longer than selecting the
columns, rows and then unhidding them

Glad to help.

Sandy

 

[AC]

Thanks for the enlightenment. Learned something rather simple here. I
guess I've never tried to hide all unused row and/or columns. )

BR,
Antje

 

[RagDyer]

Appreciate the feed-back.