| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide/Show a row based on data entry in another row
Hi Ivory Kitten,
It's odd, I have no other codes, its working fine now. The case bit was working and the hide/unhide row part was not. But it is now!? I am glad that you have got it working. how do you change the hide/unhide so that it hides when empty or a certain value? Change: Rows(19).EntireRow.Hidden = IsEmpty(rng.Value) to Rows(19).EntireRow.Hidden = Not IsEmpty(rng.Value) --- Regards, Norman |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Based of Cells Based on Data Entry in anoth | Excel Discussion (Misc queries) | |||
| Hide & Show Rows based on Check Boxes | Excel Discussion (Misc queries) | |||
| Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
| How do I hide spreadsheet range from data entry? | Excel Worksheet Functions | |||
| Macro to Hide/Show Columns based on control cell value | Excel Programming | |||
Hybrid Mode
