| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically hide column or row if a cell value meets criteria
I need a macro or formula that will automatically hide a row or column
based on an entry in a specific cell. For instance, =IF(D2="",*****,D2) with ***** being the formula or =IF(C3=0,Rows("3:3").Select,Selection.EntireRow.Hi dden=True,C3) of course this isn't working but something like this would be great Thanks so much for your continued assistance. Don |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting a Value IF a cell meets a criteria | Excel Discussion (Misc queries) | |||
| How do I count in column A when it meets all criteria in three col | Excel Worksheet Functions | |||
| How can I get a cell to Flash if it meets a certain criteria in Ex | Excel Worksheet Functions | |||
| How do I go to the next cell that meets criteria | Excel Discussion (Misc queries) | |||
| Highlight a row automatically if a cell meets certain criteria | Excel Worksheet Functions | |||
Threaded Mode
