View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
J.Smith
 
Posts: n/a
Default Function: cell contents formula or value?


You can use a custom function like:
Function IsFormula(rng1 As Range) As Boolean
IsFormula = rng1.HasFormula
End Function

Also, you can see it directly on the screen using CTRL+~

Hope this helps,
Miguel.


Thank you, Miguel! I was hoping, there would be a spreadsheet function, but
looks like there is none. If that's the case, then, of course, a VB function
is the last resort.

Thanks, again, for your reply.