| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to hide rows
Thank you
-- Thank you! "B Lynn B" wrote: How about, instead of code, add a column with formula that resolves to True if your condition is met, then just apply a filter? e.g. new column A, with formula in A2 "=or(b2<0,c2<0,d2<0,e2<0)" with arguments for as many cells to the right need to be tested for 0 value. "Doug" wrote: What is a good macro to hide rows in a table selected range that have "0" values? Reason for wanting this if I filter any one column for values of "0" then it is likely to hide values in other columns that are not "0". I want to show all rows that have any value other than "0" in a selected range. Can you help me please? -- Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro code to hide rows and not calculate hidden rows | Excel Discussion (Misc queries) | |||
| Macro to hide rows | Excel Discussion (Misc queries) | |||
| Macro to hide rows? | Excel Programming | |||
| Hide rows with macro | Excel Programming | |||
| Macro to hide rows | Excel Programming | |||
Threaded Mode
