Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
pivot table - subtotal below detail | Excel Discussion (Misc queries) | |||
Subtotal function | New Users to Excel | |||
Subtotal by two columns at once | Excel Discussion (Misc queries) | |||
Subtotal And Countif | Excel Discussion (Misc queries) | |||
delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) |