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