Hi,
I'm trying to fill a cell with information but i'm getting the "block if error". any help would be gratefully received.
Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Range("O9").Value = YES Then Range("X9").Value = "[email protected]" If Range("O9").Value = NO Then Range("X9").Value = "" Else Range("X9").ClearContents End If Application.EnableEvents = True End Sub
Bookmarks