Depending on what's in C126, you may need:

=SUM(INDIRECT("'" & C126&"'!e36"):(INDIRECT("'" & C126&"'!e49")))*1000

The additional apostrophes won't hurt if they're not needed.

Mark wrote:

Just wanted to extend a thanks; saved me a few hours work. Works great;
=SUM(INDIRECT(C126&"!e36"):(INDIRECT(C126&"!e49")) )*1000

where C126 is tje definite name for my worksheets.

"Ardus Petus" wrote:

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?




--

Dave Peterson