filter for non-formulas

S

S. H. Drew

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?
 
F

Frank Kabel

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)
 
Top