Replies

Thanks for you help!

I don’t know why but it is just not working for me. The word that I’m looking for is “Total”, does the captial “T” make a difference?

Tell me if I’m wrong, but I think this is reading for the cell to equal “total”. Is it possible for the macro to read that the cell contains the word “Total”, because the cell contains other information as well.

Thanks for the help.

Thanks!

Thanks so much for the quick response

Thanks I’ll try that.

Thanks

Thank-you very much!

Hi John,

I used your program and it worked perfectly. Just to bother you some more, if I wanted it look for cells with #N/A instead of the blank cell, how would I do that?

Thanks everyone for all your help.

Thanks I’ll try it right away.

I really need to delete the formula. I have to have the cells in column A and B to to empty.

Here is the situation. I have the two formulas in all the cells in column A and B. They both reference to the cells in column C. I want to delete the formulas in the cells of columns A and B that have cells in column C with no data. Is this possible? or am I just confusing you?

Hi Wassim,

I tried the macro you wrote for me and it works very good, but there is one thing. When I delete the row I notice that the data from the previous row has moved up a row and so I don’t think I should be deleting entire rows. How would I only delete the data that is in the cells of colume B and C of the selected rowusing your example?

Thanks for such a quick reply.