Deleting Zero after Subtotal
 

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

Do you mean delete the contents or the 'cell'?

"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

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

Select range and do Edit / Replace / Replace 0 with nothing BUT make sure you
check the option 'Match Entire Cell Contents only' You can just record this and
drop it onto the end of your macro.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"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


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.786 / Virus Database: 532 - Release Date: 29/10/2004

Thanks to all!

"Ken Wright" wrote:

Select range and do Edit / Replace / Replace 0 with nothing BUT make sure you
check the option 'Match Entire Cell Contents only' You can just record this and
drop it onto the end of your macro.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"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


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.786 / Virus Database: 532 - Release Date: 29/10/2004