so why does this fail:
![]()
Private Sub HideRowsWithinProgramming_DesignPhase() Dim xyz_rows As Range Set xyz_rows = Sheet5.Range("C:C").Find("exmaple", , xlValues, xlWhole, xlByRows, , True).Resize(3, 1) If something here Then 'You can ignore the specifics of this IF statement as this isnt the problem. xyz_rows.EntireRow.Hidden = True Else xyz_rows.EntireRow.Hidden = False End If End Sub
Run-Time Error '91'
Object variable or with block variable not set
Bookmarks