VBA Code showing runtime error '13'

[arooney88]

I was tasked with fixing this macro that isn't working but I don't know a lot about setting variables

Here is the code

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target = [BF2386] Then
If Target.Value = "Review Completed" Then
Mail_small_Text_Outlook
End If
End If
End Sub

BF2386 shows 'In Process' until someone manually changes it to "Review Completed"

I'm assuming the error that is showing relates to 'Target' but I'm not sure.

Any help would be great! Thanks!

 

[K e v i n]

Hi,
Try the following

Private Sub Worksheet_Change(ByVal Target As Excel.Range)


    Select Case Target.AddressLocal
        Case "$BF$2386"
            If Target.Value = "Review Completed" Then
                Mail_small_Text_Outlook
            End If
    End Select
    
End Sub