Hiding list of rows in VBA

[CDienst]

Hello,

I'm trying to use a macro to hide (more accurately to unhide) a list of rows. I currently have it working as (without the comment markers)

         '   With Rows("62")
         '       .Hidden = Not .Hidden
         '   End With
         '   With Rows("65")
         '       .Hidden = Not .Hidden
         '   End With
         '   With Rows("66")
         '       .Hidden = Not .Hidden
         '   End With

I'm trying to condense it to something like

Sheet1.Rows("62,65,66").Hidden = False

But this leaves the rows hidden (no error)

How do I interact with a list of rows like that?

I tried something with EntireRows, but I read that that's read-only and have since assumed anything with EntireRows won't let me change stuff. Is that right?

Thanks

 

[Rick Rothstein]

Try it like this...

Sheet1.Range("A62,A65:A66").EntireRow.Hidden = False

 

[Fluff]

Beaten2it

 

[CDienst]

Huh, I really could have sworn I tried it exactly like that before, but it works. Thanks

 

[Rick Rothstein]

Huh, I really could have sworn I tried it exactly like that before, but it works. Thanks

Perhaps you tried it like that but used Rows instead of Range.