Help require to delete the numbers conditionally

[mso3]

Hi friends,
I want to delete the marks in the following columns if the column ‘ci’ contains: F4, F5, F6, F7, F8, F9.

The total columns in which I want to delete the marks are: ‘j, p, v, ab, ah, an, at, az, bg, bj’
In other cases no deletion is require for 'Pall, F1, F2, F3'.

Please suggest me a vba code for it.

Any help will be appreciated.

Thanking you,

[nilem]

Hi mso3,
try it

Please Login or Register  to view this content.

[mso3]

Hi Nilem,
Excellent! it's working fine as per my requirement.

Thank you and have a nice day.