View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default ISBLANK for a Range

Yep. That's why I included this line...

If the formula returns text, you could use:

Sige wrote:

Hi Dave,

& text("your comment here",";;;")

Was not what I was thinking about, but does the same imo ...
Besides that it converts the cell to Text.

Thx Sige


--

Dave Peterson