Thread: How do I make a cell truly empty using an "If" statement?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
  
Posts: 3,986
Default How do I make a cell truly empty using an "If" statement?
Try ActiveCell.Clear

"ALHR" wrote:

If the condition is false, I want the cell to be empty. When I use ""
counta() and other functions treat the cell as text.

Thank you

Reply With QuoteReply With Quote