VBA - Unhide multiple rows

Question

Hi everyone,

I'm having a massive issue here. Don't know why it's doing it. I want to hide/unhide multiple rows in one hit but it doesn't seem to work (the easy way), however the longer winded way does work (specify one row, unhide, then the next row, unhide). It's really getting on my nerves!

Here's the code:

        If Range("H37") = "1" Then

            Range("225,226,227,557,558").EntireRow.Hidden = False

        End If

Why doesn't it work? I'm fairly sure I've used this exact code before and it's worked.

Thanks,

Dan

Answer 1

Either of the following 2 lines works.

Range("225:225, 226:226, 227:227, 557:557, 558:558").EntireRow.Hidden = False

Range("A225, A226, A227, A557, A558").EntireRow.Hidden = False