I know how to use the End(xlUp) property to find the last row with data.
However, I have a sheet full of formulas which return either a value or NULL.
Using End(xlUp) returns the last row containing anything, including formulas.
How do I find the last row that contains NON-NULL VALUES resulting from
these formulas.

For example, I have 20 rows with formulas in them.
Only the first "x" rows have non-null values resulting from these formulas.
The remaining (20 - "x") rows contain the formulas but they return null
values.
How do I determine the value of "x"?
--
Will