Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi At the moment I have this code to hide entire row
and it is working fine. Sub HideRows() Dim MyRange As Range, cl As Range Set MyRange = Sheet3.Range("A23:IV25") Application.ScreenUpdating = False For Each cl In MyRange If cl.Value < "Minimum" Then cl.EntireRow.Hidden = True Next cl Application.ScreenUpdating = True End Sub Now another question is How can I hide the Entire Range("A23:IV25") if the Value is "Minimum"? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Select entire rows if between date/time range | Excel Programming | |||
Hide rows within range if B? = X | Excel Programming | |||
Code for Excel 2007 to hide rows based on sum of several rows not ina range | Excel Programming | |||
Hide/Delete entire rows based in the content of one cell | Excel Discussion (Misc queries) | |||
Hide Unapplicable Ranges of Entire Rows | Excel Programming |