My needs "might" be a bit more limited. I do realize that Excel, VBA, UDF can manipulate values.

That said I need to be able to find undocumented (almost always, unlabeled additions, subtractions
and/or * or / of same) in formula strings. The user then needs to document those constants.

Obviously my game plan can be made difficult by those sophisticated accountants who may manipulate
values in hidden cells, hidden formulas, Interior.ColorIndex = Font.ColorIndex, ranges, sheets or
functions.

I have proceedures to catch all the above except for functions.

Below are some notes from your prior work that I collected; with current comments:

'From: Ron Rosenfeld
'Subject: How in to parse constants in formula to cells
'Date: Mon, 27 Nov 2006 09:05:29 -0500
'Newsgroups: microsoft.public.Excel.programming
'With regard to some of the issues:
' it returns the negative signed values
' it does NOT return "within string" constants
Here I think you mean the formula string Yes/No?
or do you mean "123456" within a Function?
i.e. VLookup
' it returns 3% as 3
' it returns all constants within a function
This is OK as surprises can occur as a result

Realizing that I am now to be a dead man resulting from my limited perspective, what have I missed?
Gulp!

EagleOne

Ron Rosenfeld wrote:

On Sun, 10 May 2009 13:11:42 -0400, wrote:

Your comment "A work in progress" is extremely interesting to me.

Silly me, I thought I was close that goal - with 100% your help even!

What are some examples/situations your are struggling with?

In short, I do not know what I do not know. I thought I was near heaven.

EagleOne

Well, in addition to parsing out constants and operators, you would also need
to parse out Functions; Names; Function arguments; cell addresses and ranges in
a variety of formats; handle arrays properly; and so forth.
--ron