Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

UnHide non-consecutive rows - VBA

  Asked By: George    Date: Oct 18    Category: MS Office    Views: 944
  

A simple but vexing problem. I need to unhide non-consecutive rows &
this is the code I have -

Rows("44:45").Select
Selection.EntireRow.Hidden = False
Rows("47").Select
Selection.EntireRow.Hidden = False
Rows("50:53").Select
Selection.EntireRow.Hidden = False

What I want to do is to group the rows in one line then hide them at
once & I have tried many variations (search XL groups & googled) but
can't get it to work -

'To unhide all Rows in range
Range("44:45, 47, 50:53").EntireRow.Hidden = False

I have had "Runtime error 13" & "mismatch error"

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Boyce Fischer     Answered On: Oct 18

Try
Range("44:45, 47:47, 50:53").EntireRow.Hidden = False

 
Didn't find what you were looking for? Find more on UnHide non-consecutive rows - VBA Or get search suggestion and latest updates.




Tagged: