filter for non-formulas
 

I have a list of data. Is there a way I can filter a column of rows to
extract only those cells that do not contain formulas?

Hi
you could use a helper column together with a UDF. Put the following
code in one of your modules:
public function is_formula(rng as range)
is_formula=rng.hasformula
end function

and use this in your helper column:
=IS_FORMULA(A1)

--
Regards
Frank Kabel
Frankfurt, Germany

"S. H. Drew" schrieb im Newsbeitrag
...
I have a list of data. Is there a way I can filter a column of rows
to
extract only those cells that do not contain formulas?