View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brotherharry Brotherharry is offline
external usenet poster
 
Posts: 21
Default how to find #ref! invalid cell references within cell formula


hmm, if I use the worksheet Ctrl+F find dialog, I can search for #REF!
which will pick it up, but the issue is I don't know that I need to do
it if the formulas are otherwise producing numeric results