Quote Originally Posted by Paul_Hossler View Post
In the worksheet code module, try using the Change event handler


Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
    If IsError(Me.Range("N9").Value) Then
        Me.Rows(23).Hidden = True
        
    ElseIf Len(Me.Range("N9").Value) = 0 Then
        Me.Rows(23).Hidden = True

     Else
        Me.Rows(23).Hidden = False
    
    End If

End Sub
I did a test where N9 is the result of a VLookup()
Hi Paul,

On your page woks fine but vlookup value comes from a election another sheet. I change the vlookup value for another sheet on you worksheet and realised it also stops working .

I have a sheet lets call it sheet1 where I have a dropdown box with options, on sheet2 I have the vlookup value (N9) from the drop down o sheet1. On the same sheet2 I have on row 23 a link to the vlookup value from shee2 N9.I need row 23 to hide if no value is selected on Sheet 1 drop down box, thus not populated N9 on sheet2.

I initially had this code , and it worked but but because I have it on sheets it gave me an error 28 on no stack space:

Private Sub Worksheet_Calculate()
Range("A22:A22").EntireRow.Hidden = (Range("N9").Value = "")
Range("A23:A23").EntireRow.Hidden = (Range("N10").Value = "")
Range("A24:A24").EntireRow.Hidden = (Range("N11").Value = "")
End Sub