Need help creating a macro to clear 2 non-consecutive cells in a range

[gophil1]

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.
***************************************************

Please Login or Register  to view this content.

[alansidman]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[gophil1]

Thank you, sorry for the error; I've corrected my post. I thought that I was forgetting something.

[Marc L]

As a beginner starter :

Private Sub Worksheet_Change(ByVal Target As Range) 
        Application.EnableEvents = False 
    Select Case Target.Address 
           Case "$B$12", "$C$12" 
                If Join(Application.Index([B12:C12].Value2, 0), "") = "" Then [K12].ClearContents 
           Case "$G$36" 
                If Target.Value2 = "" Then [K36].ClearContents 
    End Select 
        Application.EnableEvents = True 
End Sub  

Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

[gophil1]

I had to make the below modification in order to get the clear contents for cell K12 to work, but your solution works great. Thanks so much.
*****************

Please Login or Register  to view this content.

[Marc L]

As you did not explain there were merged cells …

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.