Results 1 to 13 of 13

Hide Multiple Rows Based upon a variable

Threaded View

  1. #4
    Forum Contributor
    Join Date
    12-20-2011
    Location
    United States, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    295

    Re: Hide Multiple Rows Based upon a variable

    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
    Last edited by clemsoncooz; 02-22-2012 at 11:55 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1