Thanks in advance for help with this question. Please see the picture below...
After I enter the value in the Project column, Level Calculates from a VLookup, with an error trap that returns 0 if the lookup fails (If(IsErr...
When I leave the Project cell I want the Activity column to autofill with 'Admin', where the VLookup has returned a 0.
Here's my code... which isn't working.
Thanks!
MB
After I enter the value in the Project column, Level Calculates from a VLookup, with an error trap that returns 0 if the lookup fails (If(IsErr...
When I leave the Project cell I want the Activity column to autofill with 'Admin', where the VLookup has returned a 0.
Here's my code... which isn't working.
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim ThisRow
ThisROw = Target.row
If Target.Column = 4 Then
Dim PLevel
PLevel = Range("F" & ThisRow).Value
If PLevel = 0 Then
Range("F" & ThisRow).Value = "Admin"
End If
End If
Thanks!
MB