Results 1 to 6 of 6

Need Macro to Auto hide rows

Threaded View

cmwood Need Macro to Auto hide rows 01-23-2013, 11:48 PM
cmwood Re: Need Macro to Auto hide... 01-24-2013, 12:06 AM
cmwood Re: Need Macro to Auto hide... 01-24-2013, 12:11 AM
Patnaik Re: Need Macro to Auto hide... 01-24-2013, 12:50 AM
arlu1201 Re: Need Macro to Auto hide... 01-24-2013, 12:26 AM
arlu1201 Re: Need Macro to Auto hide... 01-24-2013, 10:47 AM
  1. #3
    Registered User
    Join Date
    01-23-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Need Macro to Auto hide rows

    This seems to work but I have to run it for it to hide the completed. It doesn't do it in real time
    Sub Macro1()
       
       Dim myrange As Range
      Set myrange = Range("M:M")
       For Each cell In myrange
       If cell <> "" Then
       If cell.Value = "Complete" Then
        cell.EntireRow.Hidden = True
        End If
        End If
        Next cell
    
    End Sub
    Last edited by arlu1201; 01-24-2013 at 12:26 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