What type of data is in the range? Is it text, numeric, or could it be both?
Are there any formulas in the range that return formula blanks ("") ?

--
Biff
Microsoft Excel MVP


"Bill Brehm" <don't want spam wrote in message
...
I've tried a bunch of ideas but no luck yet.

I used to use COUNTA() to find the number of cells in a column so I could
create an array reference to the range of cells with values using
OFFSET(). Now my column may have some blank entries. COUNTA() still
returns the number of non-blank cells so my range array falls short by the
number of blank cells.

How can I find the row number of the last cell that is not blank. I need
this in a worksheet function, not a macro or not selecting with menu
commands.

Thanks...