Greetings,
I have been working on this for most of the day. I am wanting to hide rows within a Range with a specific cell is blank.
For example: Sheet24.Range ("F18:F270"), Sheet24.Range ("F274:F526"), and so forth. The following code searches the entire worksheet.
Sub HideRows() Application.EnableEvents = False Application.ScreenUpdating = False 'This code "searches" rows 17 through 2318. 'I am needing to search specific Ranges. Sheet24.Range("F17:F" & Sheet24.Range("F" & Rows.Count).End(xlUp).Row).SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True Application.EnableEvents = True Application.ScreenUpdating = True End Sub
Bookmarks