Thread
:
Reference Worksheet Name
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
Posts: n/a
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?
Reply With Quote