Please help, can't unhide columns

[Meenie]

I have a YTD worksheet at the end a workbook filled with monthly worksheets.
Column A and B have somehow become hidden - and I don't know why - I didn't hide them!

I go to edit/go to/ and enter A1/hit OK
Then I go to Format/column/unhide
and nothing happens

I go up to the top corner box (select all) and see if I can drag it open, but cannot.

Any ideas?

 

[Charlie45]

Instead of Format/column/unhide

Try Format/column/Column width and change the width to somthing other than 0

 

[Meenie]

Instead of Format/column/unhide

Try Format/column/Column width and change the width to somthing other than 0

Sorry, I did that too. It says the column width is 1.43

 

[jberwald]

Go to that top corner box (select all) but instead of hitting it - move your cursor every so slightly between that box and column c (your first column showing) you should get a symbol of two straight lines with little arrows pointing east and west. Now click and grab and open the hidden columns.

 

[rs2k]

Hi There,

Try running this code;

Sub Macro1()

    Columns("A:B").Select
    Selection.EntireColumn.Hidden = False
End Sub

HTH
Colin

 

[Meenie]

Re: Please help, can't unhide columns - found it

I had the panes frozen to show column and row headings, when I unfroze it, columns a and b re-appeared.
Why would they disappear?
the other worksheets are frozen in the same place and columns a and b are there to see!
grrrrr