PDA

View Full Version : Solved: How to Unhide Col 'A' ?



RonMcK
10-28-2008, 09:19 AM
Title has the question du jour.

Help (Excel 2004 in Mac Office) tells me:
"Tip If the first row or column of a worksheet is hidden, click Go To on the Edit menu. Type A1 in the Reference box, and then click OK. Point to Row or Column on the Format menu, and then click Unhide."
However, it does not seem to be working. I also tried this little macro that I recorded and edited:Sub Macro1()
'
' Macro1 Macro
' Macro recorded 10/28/2008 by Ron McKenzie
'

Columns("E:F").Select
Selection.EntireColumn.Hidden = True
Range("A:G").Select
Selection.EntireColumn.Hidden = False
End Sub
Again, no joy.

Suggestions?

Thanks,

Adonaioc
10-28-2008, 09:27 AM
Sub UnhideColA()

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

End Sub

RonMcK
10-28-2008, 09:30 AM
Thank you but that also doesnot work for me.

RonMcK
10-28-2008, 09:45 AM
Found my problem: Had Frozen Frames; once I unfroze Col A became visible.

Thanks!!