View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mark kubicki mark kubicki is offline
external usenet poster
 
Posts: 32
Default 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