If you only want to have the appearance of blank cells then use conditional
formatting
If Cell Value = 0 then format <font colour = white (assuming cell
backgrounds are white)
This will cause to zeros to be invisible
"Amber M" wrote in message
...
I've created a macro that, upon entering info (just numbers as text, not
$$)
into approx. 10 columns and 75 rows, will sort, subtotal and calc a
formula.
Problem: If a cell contains no info the macro will automatically put in a
0.
Is there a way to quickly delete all the cells with only a 0 without
deleting
the numbers that should contain zeros (ie. 100, 305...)??
Thanks
|