Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
why can't hide zero's based on a zero valuer in range
Sub Hidezeros()
Dim rRange As Range For Each rRange In Range("A17", Range("A41").End(xlUp)) rRange.EntireRow.Hidden = _ (rRange = 0 And Len(rRange) = 1) Next rRange End Sub I have a macro I found for hiding any rows where a zero is in column A for the range of A17 to A41. It is a simple quote sheet and if nothing is entered in the qty field then those rows shoul dhide only not delete when a button is pushed on sheet Also how would I say ranf A17 -to A25 & A27 to 31 - tow disconnected ranges. thank you for your help and time on this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide row based on cell value | Excel Worksheet Functions | |||
Hide row based on cell value | Excel Worksheet Functions | |||
Hide a row based on a cel value | Excel Discussion (Misc queries) | |||
Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells? | New Users to Excel | |||
Hide Row Based on cell value | Excel Programming |