Results 1 to 9 of 9

Show hidden rows

This is a discussion on Show hidden rows within the Excel Questions forums, part of the Question Forums category; Hi, I have this trouble: I have hidden some rows in my workbook. Then I saved this workbook and closed ...

  1. #1
    Board Regular
    Join Date
    Jan 2004
    Location
    Silesia
    Posts
    98

    Default Show hidden rows

    Hi,
    I have this trouble: I have hidden some rows in my workbook. Then I saved this workbook and closed it.
    Now I have reopened it and I would like to show some hidden rows again. When I try to use VBA code, there comes an error message.
    Does anybody know a solution?
    Bruno

  2. #2
    New Member
    Join Date
    Nov 2002
    Posts
    33

    Default Re: Show hidden rows

    To unhide rows:

    1. select the rows either side of the hidden area
    2. from the menu select Format > Row > Unhide.

    With VBA I think the code is:

    Rows("x:y").EntireRow.Hidden = False

    Where x and y are the start and end rows to unhide.

  3. #3
    Board Regular
    Join Date
    Jan 2004
    Location
    Silesia
    Posts
    98

    Default Re: Show hidden rows

    Yes, as you write it works, but not in my case.
    I have hidden for row 8:65536, it means to the end. So I cannot select hidden rows.
    VBA code shows an error message and then Excel freezes up.
    So any other idea?

  4. #4
    New Member
    Join Date
    Nov 2002
    Posts
    33

    Default Re: Show hidden rows

    I just tried running the two subs shown below, and it worked fine for me. What is the error message?

    Sub Hide()

    Rows("8:65536").EntireRow.Hidden = True

    End Sub

    Sub Unhide()

    Rows("8:65536").EntireRow.Hidden = False

    End Sub

  5. #5
    New Member
    Join Date
    Nov 2002
    Posts
    33

    Default Re: Show hidden rows

    As another idea try selecting all cells (CTRL-A) and then selecting unhide from the Format > Row menu.

  6. #6
    Board Regular MartinK's Avatar
    Join Date
    Oct 2003
    Location
    Prague, CZ / Zagreb, HR
    Posts
    384

    Default Re: Show hidden rows

    So I cannot select hidden rows.
    VBA code shows an error message and then Excel freezes up
    Hello,

    Silesia?

    Yes, hidding the 65536th row / 256th column sometimes causes troubles, don't hide it unless you must.

    Try if explicit selecting of A1 before you run the hidding/unhidding helps:
    So I cannot select hidden rows.
    Sub blah()
    [A1].Select
    [8:10].EntireRow.Hidden = False
    End Sub


    Martin

  7. #7
    Board Regular
    Join Date
    Jan 2004
    Location
    Silesia
    Posts
    98

    Default Re: Show hidden rows

    Thank you both guys ,
    Martin, your solution works of course, but not in case I save and close my workbook and open it again. I think this is the source of trouble.
    Then comes an error message:
    Run-time error '1004'
    Application-defined or object-defined error
    Maybe it is my local trouble.
    The only thing working by me is CTRL-A and then unhide from the menu as chappelg wrote. Thanks
    Because I hid just empty rows I finally decided to use rows.insert method instead of hidding. It works but I am not sure this way is right

    bruno

  8. #8
    Board Regular MartinK's Avatar
    Join Date
    Oct 2003
    Location
    Prague, CZ / Zagreb, HR
    Posts
    384

    Default Re: Show hidden rows

    If it works for you, fine, you can also have a look at a similar discussion here:
    http://www.utteraccess.com/forums/sh...=&fpart=3&vc=1

    Martin

  9. #9
    Board Regular
    Join Date
    Jan 2004
    Location
    Silesia
    Posts
    98

    Default Re: Show hidden rows

    Hi Martin,
    thank you for an interesting link.

    bruno

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com