Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide rows within a range IF...
Greetings,
Newbie here so any help is appreciated. Within the active worksheet, within the row range of Row 7 thru Row 1004, if the value in Column CK for that Row is = 0, then hide the entire row. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide rows within a range IF...
One way sub hideifzero() for i=1004 to 2 step-1 if cells(i,"ck")=0 then rows(i).hidden=true next i end sub -- Don Guillett Microsoft MVP Excel SalesAid Software "drumsab" wrote in message ... Greetings, Newbie here so any help is appreciated. Within the active worksheet, within the row range of Row 7 thru Row 1004, if the value in Column CK for that Row is = 0, then hide the entire row. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide rows within a range IF...
Thanks.
My spreadsheet is fairly big. Any way to make the "hiding rows" go faster than it does with this code? "Don Guillett" wrote: One way sub hideifzero() for i=1004 to 2 step-1 if cells(i,"ck")=0 then rows(i).hidden=true next i end sub -- Don Guillett Microsoft MVP Excel SalesAid Software "drumsab" wrote in message ... Greetings, Newbie here so any help is appreciated. Within the active worksheet, within the row range of Row 7 thru Row 1004, if the value in Column CK for that Row is = 0, then hide the entire row. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide rows within a range IF...
Or assisgn this to a shape or button from the drawing toolbar
Sub ToggleAutoFilter() If ActiveSheet.AutoFilterMode Then ActiveSheet.AutoFilterMode = False Else Range("ck1").AutoFilter Field:=1, Criteria1:="<0" End If End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett" wrote in message ... Modify this to suit Sub FilterOutZero() Range("a1").AutoFilter Field:=1, Criteria1:="<0" End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "drumsab" wrote in message ... Thanks. My spreadsheet is fairly big. Any way to make the "hiding rows" go faster than it does with this code? "Don Guillett" wrote: One way sub hideifzero() for i=1004 to 2 step-1 if cells(i,"ck")=0 then rows(i).hidden=true next i end sub -- Don Guillett Microsoft MVP Excel SalesAid Software "drumsab" wrote in message ... Greetings, Newbie here so any help is appreciated. Within the active worksheet, within the row range of Row 7 thru Row 1004, if the value in Column CK for that Row is = 0, then hide the entire row. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to hide rows with zero in specifc column range | Excel Discussion (Misc queries) | |||
Hide all rows within a range except one? | Excel Discussion (Misc queries) | |||
Hide columns & rows that contain "0" or blank in a range of cells | Excel Worksheet Functions | |||
Hide blank rows in a range | Excel Programming | |||
Hide Unused Cols & Rows in a Range | Excel Programming |