Results 1 to 30 of 30

Using Value in Cell to hide/unhide rows

Threaded View

maayub15 Using Value in Cell to... 02-02-2012, 02:48 AM
maayub15 Re: Using Value in Cell to... 02-02-2012, 03:33 AM
rscsmith Re: Using Value in Cell to... 02-02-2012, 04:29 AM
maayub15 Re: Using Value in Cell to... 02-02-2012, 08:54 PM
royUK Re: Using Value in Cell to... 02-02-2012, 09:14 AM
maayub15 Re: Using Value in Cell to... 02-02-2012, 08:44 PM
rscsmith Re: Using Value in Cell to... 02-02-2012, 11:26 PM
maayub15 Re: Using Value in Cell to... 02-03-2012, 03:11 AM
maayub15 Re: Using Value in Cell to... 02-03-2012, 03:20 AM
rscsmith Re: Using Value in Cell to... 02-03-2012, 04:20 AM
maayub15 Re: Using Value in Cell to... 02-06-2012, 02:03 AM
maayub15 Re: Using Value in Cell to... 02-06-2012, 02:10 AM
maayub15 Re: Using Value in Cell to... 02-08-2012, 12:55 AM
rscsmith Re: Using Value in Cell to... 02-08-2012, 06:01 PM
maayub15 Re: Using Value in Cell to... 02-10-2012, 03:40 AM
rscsmith Re: Using Value in Cell to... 02-12-2012, 06:29 PM
maayub15 Re: Using Value in Cell to... 02-12-2012, 09:59 PM
rscsmith Re: Using Value in Cell to... 02-13-2012, 07:44 PM
maayub15 Re: Using Value in Cell to... 02-14-2012, 01:54 AM
rscsmith Re: Using Value in Cell to... 02-15-2012, 12:33 AM
maayub15 Re: Using Value in Cell to... 02-16-2012, 09:27 PM
rscsmith Re: Using Value in Cell to... 02-16-2012, 09:56 PM
maayub15 Re: Using Value in Cell to... 02-22-2012, 10:31 PM
maayub15 Re: Using Value in Cell to... 03-01-2012, 02:46 AM
rscsmith Re: Using Value in Cell to... 03-01-2012, 06:15 PM
maayub15 Re: Using Value in Cell to... 03-07-2012, 10:26 PM
maayub15 Re: Using Value in Cell to... 03-07-2012, 10:59 PM
maayub15 Re: Using Value in Cell to... 03-14-2012, 04:18 AM
rscsmith Re: Using Value in Cell to... 03-14-2012, 08:35 AM
maayub15 Re: Using Value in Cell to... 03-15-2012, 02:23 AM
  1. #2
    Registered User
    Join Date
    02-02-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: Using Value in Cell to hide/unhide rows

    I manage to make some progress. I used the following codes to perform the function

    Sub HIDEROWUSINGTEXT()
    If Range("A9").Value = 5 Then
    Rows("7:7").EntireRow.Hidden = True
    Else
    Rows("7:7").EntireRow.Hidden = False
    End If
    End Sub
    By having a value 5 in cell A9 and when i ran the macro, row 7 got hidden. However, i had to run the marco everytime i change the value in the cell. Maybe if anyone can help me modify the codes to hide/unhide row 7 every time i change it would be good...
    Last edited by maayub15; 02-02-2012 at 08:43 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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