VB code to delete value in a cell based on finding another Value

[psoft]

Hello,

I would like to remove(delete) the value in one of the cell in the report but first I need to find the row which has "TOTAL" and in the same row in column "G" cell value should be deleted. The row number in which "TOTAL" value can vary based on number of accounts in the report ...so it may vary so I cannot hard code Row #. See example below. Row #131 has column C has TOTAL and Cell of 131 row and column G which has 102% should be deleted. I need a VB code for this.

column B C D E F G
131 TOTAL 0.00 0.00 0.00 102 %

Thanks and appreciate in advance

[ragulduy]

Range("G" & worksheetfunction.match("TOTAL",columns(3),0)).clearcontents

[psoft]

Thanks!! it worked. You are so fast!!!

Sorry, I just now realized that there is another row in the middle of the Report has value Total as well. So I want to make sure this TOTAL is the last row in the Column C .

I will add Reputation and mark solved once I get your response. Thanks again for your help.

[ragulduy]

Maybe something like:

Please Login or Register  to view this content.

[psoft]

Great! Your are awesome...Now I feel confident that I am looking the last row ONLY.

Marking as solved.