FILTER CELLS CONTAINING FORMULAS

[FARAZ QURESHI]

I have quite a huge list and have to insert different sort of formulas
depending upon the criteria. In the end I am most of the time in a doubt
whether all the cells are containing formulas or there still exist some
figures inserted manually. Could there be some kind of formula resulting as
"=ISFORMULA(A1)" reflecting whether A1 contains any formula or not?

Thanx!

 

[Max]

"=ISFORMULA(A1)"

Trawling google reveals this UDF
(add to a general module in your workbook)

Function IsFormula(Cell)
IsFormula = Cell.HasFormula
End Function

Then you could use it eg in E2, copied down:
= --isformula(D2)
Col E will return 1's for cells in col D with formulas,
zeros for cells w/o formulas
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000 Files:358 Subscribers:55
xdemechanik

 

[FARAZ QURESHI]

HEY MAX
U'R THE BEST
THANX!!!!!!!!!

 

[Rick Rothstein \(MVP - VB\)]

Perhaps you can make use of this technique. Select all the cells you want to
check, click Edit/Find in Excel's menu bar (or just key in Ctrl+F instead)
to bring up the Find dialog box. If the extra options are not showing, click
the "Options>>" button to display them. Type =* (the is equal sign,
asterisk) in the "Find what" field, select "Sheet" in the "Look in" drop
down, select "Formulas" in the "Look in" drop down, then click the "Find
All" button and follow that by keying in Ctrl+A. Finally, click the Close
button and all cells **with** formulas in them will be selected... you will
want to concentrate on the cells *not* selected.

Rick

 

[Max]

Welcome, glad it helped.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000, Files:358, Subscribers:55
xdemechanik

 

[Ron de Bruin]

Another way is to Select the column and use F5 > Special
And check formulas.

All cells with a formula are selected now