Results 1 to 13 of 13

Hide Rows based on "A"'s Criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-06-2007
    Posts
    105

    Hide Rows based on "A"'s Criteria

    What am I doing wrong here?

    I have a code and it doesn't error out, but it won't hide the rows either. I'm pretty sure the red is what needs to be altered. I've tried adding "Selection.", "Rows." and "Cells." and none of them are working.


    Sub Test()
    Dim Lngrow As Long
    Lngrow = Range("I5").End(xlDown).Row
    Do While Lngrow > 0
    If Cells(Lngrow, 1).Value = "Filler" Then
    Selection.EntireRow.Hidden = True
    End If
    Lngrow = Lngrow - 1
    Loop
    End Sub
    Last edited by adgjqetuo; 10-07-2009 at 10:30 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