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