View Single Post
  #2   Report Post  
ScottO
 
Posts: n/a
Default

One way that should work ...

If you use Auto Filter to filter out the Blanks, then you can select your
range in ColB and use Select Special Visible Cells Only and then operate on
the Tangible cells.

Rgds,
ScottO

"shellshock" wrote
in message ...
|
| 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
|