View Single Post
  #1   Report Post  
shellshock
 
Posts: n/a
Default differentiating between formulas and values


I have a bunch of values in column A. In column B, I'm using a
user-defined function that processes the values in column A and returns
either text of some sort or a blank.

However, even though the cells in column B appear to be unique -- well,
except for the blank cells -- the formula in each cell is essentially
identical (e.g. B1 is =UDF(A1), B2 is =UDF(A2) etc.).

I want to do an operation only on those cells in column B that are
displaying text, but I don't know how to do that automatically.

Is there a way to somehow differentiate between cells that return a
"tangible" value, and those that return a "blank" value?


--
shellshock
------------------------------------------------------------------------
shellshock's Profile: http://www.excelforum.com/member.php...o&userid=24935
View this thread: http://www.excelforum.com/showthread...hreadid=385124