Hi
I have been racking my brain on this one but cannot get it to work.
I need to select all worksheets and hide rows 46 - 53 on each one.
This is the VBA I am using...
Please can someone help me out?
It isn't hiding the rows on all worksheets
Sub HIDEROW()
ActiveWorkbook.Sheets.Select
Rows("46:53").Select
Selection.EntireRow.Hidden = True
End Sub
I have been racking my brain on this one but cannot get it to work.
I need to select all worksheets and hide rows 46 - 53 on each one.
This is the VBA I am using...
Please can someone help me out?
It isn't hiding the rows on all worksheets
Sub HIDEROW()
ActiveWorkbook.Sheets.Select
Rows("46:53").Select
Selection.EntireRow.Hidden = True
End Sub