Thread: Macro to clear range contents when cell contents are changed by us
View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.programming
Zone[_2_] Zone[_2_] is offline
external usenet poster
  
Posts: 43
Default Macro to clear range contents when cell contents are changed b
Shelly, I replied earlier, but some reason my reply didn't show up. I
cannot see any problem with my code, regardless of whether there are
formulas or not. James

"Shelly" wrote in message
...
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