Consulting

Results 1 to 4 of 4

Thread: Solved: How to Unhide Col 'A' ?

  1. #1
    VBAX Expert
    Joined
    Aug 2007
    Location
    Windermere, FL, a 'burb in the greater Orlando metro area.
    Posts
    567
    Location

    Solved: How to Unhide Col 'A' ?

    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:[vba]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
    [/vba] Again, no joy.

    Suggestions?

    Thanks,
    Ron
    Windermere, FL

  2. #2
    VBAX Regular
    Joined
    Mar 2008
    Posts
    78
    Location
    [VBA]
    Sub UnhideColA()

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

    End Sub
    [/VBA]

  3. #3
    VBAX Expert
    Joined
    Aug 2007
    Location
    Windermere, FL, a 'burb in the greater Orlando metro area.
    Posts
    567
    Location
    Thank you but that also doesnot work for me.
    Ron
    Windermere, FL

  4. #4
    VBAX Expert
    Joined
    Aug 2007
    Location
    Windermere, FL, a 'burb in the greater Orlando metro area.
    Posts
    567
    Location
    Found my problem: Had Frozen Frames; once I unfroze Col A became visible.

    Thanks!!
    Ron
    Windermere, FL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •