Thread: Macro to clear range contents when cell contents are changed by us
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Shelly Shelly is offline
external usenet poster
  
Posts: 84
Default Macro to clear range contents when cell contents are changed b
Thanks, James. But now I realize that the value of the cells isn't "0",
because there is a formula in each of these cells.

How can I do this so it will clear the F5:N5 range if A5:E5 contains no
value, but does contain formulas?
Reply With QuoteReply With Quote