How to unhide rows in VBA

snjpverma · Mar 8, 2018

When I enter this code, it works..

Code:

Rows("26:37").Hidden = True
Rows("49:52").Hidden = True

but when I enter it like this, it doesn't. Can anyone explain?

Code:

Rows("26:37", "49:52").Hidden = True

lrobbo314 · Mar 8, 2018

The Rows function doesn't take more that one argument like that. Use the Range function.

Code:

Sub HideEm()
Range("26:36,49:52").EntireRow.Hidden = True
End Sub

Peter_SSs · Mar 8, 2018

Edit: Oops, hadn't seen post #2

Instead, try

Rich (BB code):

Range("26:37, 49:52").EntireRow.Hidden = True