r.hasFormula

will be true if the cell r has a formula. If it has text that starts with an
equal sign (but still text), it will return false.



Ruthki wrote:
>
> Dave
> Will this differentiate between a keyed constant and a formula - the
> difficulty I have encountered is that the keyed constant is recognised
> as a formula and therefore result will be true for both ?
>
> --
> Ruthki
> ------------------------------------------------------------------------
> Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503
> View this thread: http://www.excelforum.com/showthread...hreadid=380978

--

Dave Peterson