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,
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,