Thread: Macro to clear range contents when cell contents are changed by us
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
stevebriz stevebriz is offline
external usenet poster
  
Posts: 195
Default Macro to clear range contents when cell contents are changed b

Steve E wrote:
So if I had formulas in those cells I'd want to use the:

Range("L" & Rchange, "T" & Rchange).Value = vbNullString

Nope....VbNullString cleans out formulas aswell.
This I don't see as problem as...I would never set the range to to
delete formulas I wanted to keep.

Reply With QuoteReply With Quote