Thread
:
HasFormula() vs. has a "numeric" entry
View Single Post
#
1
Posted to microsoft.public.excel.programming
mark kubicki
external usenet poster
Posts: 32
HasFormula() vs. has a "numeric" entry
How can I distinguish if a cell has formula entry (ex: =sum(A1:A25) ) vs. a
simple "numeric entry (ex: 123)?
-would the most efficient way be to check if Right(AnyString, 1) = "="
thanks in advance,
-mark
Reply With Quote
mark kubicki
View Public Profile
Find all posts by mark kubicki