Needing VBA code to clear contents of cell when the contents of another cell is cleared

[jeh0714]

Below is the code I am working with.

What I an trying to do now is clear the contents of columns 8 and 9 when the contents of column 7 are cleared.

Please Login or Register  to view this content.

[Winon]

Hello jeh0714,

It appears that you may have one or more Named Ranges in your Workbook, which makes a ready solution a bit of guessing in tweaking your Code.

Please try the Code below-(Untested):

Please Login or Register  to view this content.

If this does not work for you then please, attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Regards.

[jeh0714]

Sir, Thank you for the attempt, unfortunately it did not work. I have attached a sample workbook per your request.
Thank you in advance for your assistance.

[Winon]

Thank you for your response jeh0714,

Here is your Revised Code;

Please Login or Register  to view this content.

It works just fine in the sample Workbook attached below.

Regards.

[jeh0714]

Sir,

Thank you, this is exactly what I was looking for and it works as expected

James

[Winon]

Hi jeh0714,

You are welcome, glad I could help. Thank you for marking this Thread as "Solved", and also for adding to my Reputation.

It is much appreciated!

Regards.