Clear cell

[Panoos64]

Hi everyone, i would like to write a vba so that to run through col. "A" and where find the text Grand Total should clear the contents in adjacent cell in col. "B" as my below extract



Original Data

A B
Grand Total Debtor Name



Expected result

A B
Grand Total

 

[Panoos64]

Thank you Tetra. Now it works perfect and according to my data. Thanks once again for your support and your follow up. Have a great lovely day!