| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide/Show a row based on data entry in another row
I have a data entry cell at B4 where you enter a currency value. If B4 is
blank I want row 19 to be hidden and if B4 is not blank then show row 19. I've tried a heap of different things but none have worked so far. This works if you only want to hide them and your cell has a value but I can't think how to do it if it's a blank! Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 And UCase(Target.Value) = "COMPLETE" Then Target.EntireRow.Hidden = True Else Exit Sub End If End Sub |
| 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 | |||
Threaded Mode
