How to delete adjacent cells values based on one cell?

Hi Excel experts,

I have a excel sheet (2010 version) with column A containing numbers and column B & C data.
I want to delete data from B & C columns if a cell of column A = 0 (null).
For example, If i delete A1 then B1 & C1 also gets deleted
Delete A2 then B2 & C2 deleted....
delete A3 then B3 &C3 deleted ..........and so forth.

note that column B & C are populated by macro thus formula on those cells won't work. Therefore I want code to take this action.

best,
Prad

Place this code in your worksheet module:

Please Login or Register  to view this content.

Great !! it simply works like a magic...thank you so much Mumps1 for your help.

My pleasure.