Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide a row based on values
Is it possible to hide a row based on a value within the row?
If cell A1= true display row A else hide row A from view I will be running this in all versions of Excel from 97 to 2003 ar there any limitations on which will work and which will not? Any assistance is appreciated -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide a row based on values
Steve,
Are you looking for a macro to loop through a range hiding as it goes, or one that hides the row as A1 doesn't equal TRUE? If the latter, how would you reset? -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "stevenmckeon " wrote in message ... Is it possible to hide a row based on a value within the row? If cell A1= true display row A else hide row A from view I will be running this in all versions of Excel from 97 to 2003 are there any limitations on which will work and which will not? Any assistance is appreciated. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide a row based on values
Hi try this
Private Sub CommandButton1_Click() If Range("A12").Value = "True" Then Rows("9:9").Select Selection.EntireRow.Hidden = True Else Rows("9:9").Select Selection.EntireRow.Hidden = False End If End Sub good luck ross |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide a row based on values
Thanks Ross - this will do nicely!
Appreciate the assistance. ross wrote: *Hi try this Private Sub CommandButton1_Click() If Range("A12").Value = "True" Then Rows("9:9").Select Selection.EntireRow.Hidden = True Else Rows("9:9").Select Selection.EntireRow.Hidden = False End If End Sub good luck ross -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide cell values based on a condition in another cell | Excel Worksheet Functions | |||
Can visual basics hide rows based on cell values? | Excel Discussion (Misc queries) | |||
Hide Rows based on value | Excel Discussion (Misc queries) | |||
Hide a row based on a cel value | Excel Discussion (Misc queries) | |||
Predict Y-values on new X-values based on other actual X and Y values? | Excel Programming |