I know that Sheet1:Sheet3!A1:F1 can be named. But Can I have Sheet1 & Sheet3
(excluding sheet2 ?) If so, what would be the notation? Thanks

Drag the Sheet2 tab to the *right* of the Sheet3 tab,
OR
Drag the Sheet2 tab to the *left* of the Sheet1 tab.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"dindigul" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
I know that Sheet1:Sheet3!A1:F1 can be named. But Can I have Sheet1 & Sheet3
(excluding sheet2 ?) If so, what would be the notation? Thanks

I'm not sure why you'd want to do this, but I used:

Insert|Name|Define
Names in workbook: Test1
Refers to: =Sheet1!$A$1:$F$1,Sheet3!$A$1:$F$1

I used a comma as my separator since it matched my windows regional setting list
separator.




dindigul wrote:
>
> I know that Sheet1:Sheet3!A1:F1 can be named. But Can I have Sheet1 & Sheet3
> (excluding sheet2 ?) If so, what would be the notation? Thanks

--

Dave Peterson