I have a VBA procedure that loops through cells collecting information on the contents of cells with values greater than zero.

Sometimes the program will blow up when it reaches a particular cell that appears to be completely empty but which passes as 0 when the program looks at it.

I try to delete the contents of the cell but it still goes through as 0.

Any way to erase a ghost cell like this?