Deleting Rows based on their value

I'm sorry, I meant to say add a 0 value to any blank cell.

Anyone give me a little bit of help?

Please? Any sugestions?

Hi,
Give this a try!

Please Login or Register  to view this content.

Tony

I apprciate the try tony, but that didn't work.
It deleted everything and left some with blank cells in column G.
I have attached an example of what I am trying to do.
In the attachement, I copied that sheet from the workbook that I'm working on. I didn't include the entire workbook since the file is too large. But the example I have should be sufficent.
If you look at that sheet, you will see there are items with blank cells in Collum G and there are few items with actual cost, like G13, and G19, and G33.
I basically want to delete all the rows that have blank or zero values for Column G. So my idea was to assigne every cell in colum G8:G50 to zero if it is blank. That will make every cell in that range have a value of either 0 or a number greater than zero. Then it would scan the column for cells with zero values and delete them since I only want to show items that have a cost.

the attachement:

Hi,
I don't think you need to find the blanks and change them into 0. Try this instead,

Please Login or Register  to view this content.

Tony

Thank you very much Tony, problem solved.
SOS, thats great observation skills. I missed that and I'm impressed you noticed it since its really to notice.
Thanks again guys, well appriciated it.