View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Function to determine whether cell contains a formula?

Hi Don:

Remember, without any custom functions, you can locate all cells containing
formulae and count them:

first set the status bar to COUNT
next:
Edit Goto Special formulas
--
Gary's Student
gsnu200708


"Don" wrote:

All,

Is there a function (eg, in the form of =ISFORMULA(_)) that will return a
code if a cell contains a formula as opposed to a blank or a text or value?