Unhide rows in multiple worksheets using a macro in vba

[MISS_AJAZ]

Hi all,

I am currently using a macro which hides rows with a 'NO' in column A in all worksheets in the workbook. Now I need a macro which will unhide rows in all worksheets, as it is too long unhiding manually.

I need it to unhide between rows 16-55.

Can anyone help?

Thanks

 

[VoG]

Try

Sub UnhideRows()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
    With ws
        .Rows("16:55").Hidden = False
    End With
Next ws
End Sub

 

[MISS_AJAZ]

PERFECT!! Thank you