View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Josh Craig Josh Craig is offline
external usenet poster
 
Posts: 40
Default function to give me cell reference

Is there a function that returns the formula in another cell in text?

For example, if cell A1 has the formula:

=Sheet2!B2

I want B1 to say in text: Sheet2!B2