View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tjc tjc is offline
external usenet poster
 
Posts: 13
Default Show cell reference as text

How can I show a cell reference as a text? For example, if cell A1 contains
the formula =worksheet1!A1, it will return the contents of the cell
referenced. In a different cell, I'd like to show the text "=worksheet1!A1".
More specifically, I'd like to be able to extract the text "worksheet1" from
the original formula.