The rationale behind this is that yes I am building an
auditing tool. One of the things that would be useful
would be to have a tool that looks for specific and
frequent formula errors (i.e YearFrac using 360 vs 365
days or say a match without the 0 at the end). I already
have all the Excel functions loaded into a combo box. But
it would be more meaningful to have the combo box loaded
with actual functions used in the spreadsheet. Yes it
maybe a lot of work and I may just default to the entire
function list that I am currently using.



-----Original Message-----
But WHY do you want to know this? Is it really worth the
effort?


On Tue, 15 Mar 2005 13:31:20 -0800, "ExcelMonkey"
wrote:

What is a formula parser. I guess I do not that I can
test to see if its a formula. If yes, then I can count
brakcets "(" and search between the brackets for
existing
excel functions from a list.


-----Original Message-----
I expect it is. You would probably need a formula
parser about as powerful
as Excel's built in parser.

Otherwise, you would need a list of all the functions
you want to identify.

Maybe someone else has a better idea.

for a sample formula:

=IF(OR(Date2<VDate1,VDate2<Date1),NETWORKDAYS
(Date1,Date2,NWRange),
IF(OR(AND(Date1<=VDate1,Date2=VDate2),AND
(Date1=VDate1,Date2<=VDate2)),
MAX(0,NETWORKDAYS(Date1,Date2,NWRange)-NETWORKDAYS
(VDate1,VDate2,NWRange)),
IF(OR(AND(Date1<=VDate1,Date2<=VDate2),AND
(Date1=VDate1,Date2VDate2)),
IF((Date1=VDate1),0,NETWORKDAYS(Date1,VDate1-
1,NWRange))
+
IF((Date2<=VDate2),0,NETWORKDAYS
(VDate2+1,Date2,NWRange)),NA())))

--

Regards,
Tom Ogilvy

"ExcelMonkey"
wrote in message
.. .
sorry Tom. What I meant to say is it possible to
count
functions within the cell formula?

THanks


-----Original Message-----
A cell can only have one formula.

for each cell in selection
if cell.hasformula then
cnt = cnt + 1
sFormula = cell.Formula
end if
Next

you can't pass things to arrays and arrays don't
adjust.
Perhaps you have
some subroutine that does this. Then you would call
it

ProcessFormula sFormula


--
Regards,
Tom Ogilvy



"ExcelMonkey"
wrote
in message
...
Does anyone know how to search a cell and identify
and
count each formula in that cell. Then pass this
to
an
array which adjusts for redundant strings.

Thanks


.



.


.