Hello everyone. I haven't been on the site in a while, but I'm back with a problem that should be simple, but has stumped me.
I'm trying to create a macro that checks to see if cells b12:c12 are empty and if they are clears the cell contents of k12.
I also want a separate macro that checks to see if cell g36 is empty and if it is then clears the cell contents of k36.
Below is the macro that I have that accomplishes the first part, but I can't figure out how to include a macro that solves the second part of my problem.
Thanks in advance for any assistance that anyone can provide.
***************************************************
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("b12:c12")) Is Nothing Then
Worksheets("Leadsheet").Range("k12").ClearContents
End If
End Sub
Bookmarks