Display Empty Cell When Using SUM formula
Is the Total cell one of the cells cleared in your macro?
If so, why clear (delete) the formula? Just write the formula like this:
=IF(SUM(.....)=0,"",SUM(.....))
And remove that cell reference from your macro.
Also, you can simplify the macro to:
Sub NewSalesOrder()
Range("B2,B4:B13,E14").ClearContents
End Sub
--
Biff
Microsoft Excel MVP
"Koomba" wrote in message
...
I am using a Custom Sales Order Template. I use a macro to clear contents
(from previous sales order). I use SUM formula in the TOTAL cell and
wonder
if I can have the TOTAL cell show as empty (but leave formula intact)
after
macro clears contents. I am being picky here, I know.
Here is Macro:
Sub NewSalesOrder()
'
' NewSalesOrder Macro
' Clears Sales Order for new data entry
'
' Keyboard Shortcut: Ctrl+b
'
Range("B2").Select
Selection.ClearContents
Range("B4:B13").Select
Selection.ClearContents
Range("E14").Select
Selection.ClearContents
End Sub
--
Thanks from Salt Spring
|