خرید بک لینک

I am using Excel 2013. I am new to VBA. I found a code that would simply hide 2 rows (36 and 37) if my cell N39 is equal to "Passed"

I found that code but I receive the message "ambiguous name detected "Worksheet_Change" Private Sub Worksheet_Change(ByVal Target As Range) If Range("N39").Value = "Passed" Then Rows("36:37").EntireRow.Hidden = True ElseIf Range("N39").Value = "Failed" Then ows("36:37").EntireRow.Hidden = False

End If

End Sub

so I tried the name of my worksheet but it does nothing

Private Sub NRF(ByVal Target As Range) If Range("N39").Value = "Passed" Then Rows("36:37").EntireRow.Hidden = True ElseIf Range("N39").Value = "Failed" Then ows("36:37").EntireRow.Hidden = False

End If

End Sub

Any idea of what I am doing wrong?

Thank you

برچسب: نویسنده: استخدام کار تاريخ: چهارشنبه 25 فروردين 1395 ساعت: 5:49

صفحه بندی