FILTER CELLS CONTAINING FORMULAS
 

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!

--

Best Regards,
FARAZ A. QURESHI

FILTER CELLS CONTAINING FORMULAS
 

"=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" wrote:
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!

--

Best Regards,
FARAZ A. QURESHI

FILTER CELLS CONTAINING FORMULAS
 

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

Best Regards,
FARAZ A. QURESHI


"Max" wrote:

"=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" wrote:
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!

--

Best Regards,
FARAZ A. QURESHI

FILTER CELLS CONTAINING FORMULAS
 

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


"FARAZ QURESHI" wrote in message
...
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!

--

Best Regards,
FARAZ A. QURESHI

FILTER CELLS CONTAINING FORMULAS
 

Welcome, glad it helped.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000, Files:358, Subscribers:55
xdemechanik
---
"FARAZ QURESHI" wrote in message
...
HEY MAX
U'R THE BEST
THANX!!!!!!!!!
--

Best Regards,
FARAZ A. QURESHI

FILTER CELLS CONTAINING FORMULAS
 

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

All cells with a formula are selected now




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"FARAZ QURESHI" wrote in message ...
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!

--

Best Regards,
FARAZ A. QURESHI