View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default Reference Worksheet Name

Put worksheet name in a definite cell (say A1)

use INDIRECT:
=INDIRECT(A1&"!b10")

HTH
--
AP

"Leann" a écrit dans le message de news:
...
I would like to be able to change the name of a worksheet and have it
change
in all of the formulas that reference it as well. Is there an easy way to
do
this?