Thread: Checking formula type (reference to other worksheet or not)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Coulter Fred Coulter is offline
external usenet poster
  
Posts: 2
Default Checking formula type (reference to other worksheet or not)
I'm not sure if this will help, but references to a different file include
the "[" and "]" characters.

"topola" wrote:

In the worksheet cells I have two types of formulas: references to
another worksheet or summing cells within this worksheet.

Is there a formula to tell those two apart?

TIA, topola


Reply With QuoteReply With Quote