Show hidden rows

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: Show hidden rows

  1. #1
    Board Regular
    Join Date
    Jan 2004
    Location
    Silesia
    Posts
    98
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Show hidden rows

      
    Hi Martin,
    thank you for an interesting link.

    bruno

User Tag List

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