Tushar - now I have the range names and it works for the sum function but I
do not seem to be able to reference teh range with V/HLOOKUP which is really
why I want the extra spreadhseets in the range (needless to say I have price
tables that don't fit on one sheet). Any thoughts as to how to resolve this.
Thanks David

"David" wrote:

I am looking for a very simple piece of code illustrating the format for a
"3D" range ie one that spans more than one worksheet. Can anyone help. the MS
help function is utterly useless. Thanks