Defining a named Range covering multiple worksheets 1

[vedicman]

Is it possible to define a named range in XL that spans multiple worksheets? If so, please include the details on how to do it.

I've tried this:

Names in Workbook: MyRange
Refers To: =Results!$A$1:$A$65356,Results1!$A$1:$A$1700

It doesn't seem to work. Any Suggestions.

Franco

 

[combo]

You can have only cube-shaped 3D named ranges, you have to enter range reference manually:
Refers To: =Results:Results1!$A$1:$A$65356
(for worksheets named with spaces: ='Results 1:Results 2'!..., for full columns: ...!$A:$A).

combo