You can use this UDF:
Function ShowFormula(a As Range)
If Application.ReferenceStyle = xlR1C1 _
Then ShowFormula = a.FormulaR1C1 _
Else: ShowFormula = a.Formula
End Function
You may benefit from (temporarily) choosing R1C1 reference style
(Tools>Options, General tab). If for example you always reference the row
above or the column to the left, the formulas are the same and exeptions are
easily detected.
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"AndyE" <[email protected]> wrote in message
news:[email protected]...
> Is there any way to use the "=RIGHT" or "=LEFT" functions to search the
> text
> that makes up a formula, rather than the result of the formula?
>
> I have a list of formulae that reference a sequence of cells, and I need
> to
> check that the sequence isn't broken (I'm going to ask it to check that
> each
> cell reference is one away from the previous reference, and return an
> error
> message if it isn't).
>
> Thanks!
Bookmarks