Is there a reason you want to use .formular1c1?

If you really have values (not formulas) in the cell, then .value would be much
more intuitive.

If you really have a formula, do you really want to inspect something like:

=VLOOKUP(RC[-1],Sheet2!C[-1]:C,2,FALSE)

I can't imagine where .formular1c1 would make sense in the kind of code that you
posted. But maybe you have some weird things to check????

RemyMaza wrote:

<<snipped

How can I use this code to look within a formula and not value. Would
I change:

Select Case LCase(myCell.Value)
to
Select Case LCase(myCell.FormulaR1C1)

Many Thanks,
Matt

--

Dave Peterson