Matrix

Hi all,

I have two two ranges (one column)
named mat1 and mat2.
I Choose Insert/Name/Define and
Name in Workbook: Three
Refers To: =mat1,mat2
I can utilize this new name for
my graphic but I can't see this
new range in my worksheet.
{=Three} don't work ?

Thanks,

Serge

Hi Serge -

Here are a few tricks.

1. In the Define Names dialog (shortcut: Ctrl+F3), select the name, then
click in the Refers To formula, and the range will be outlined with the
moving dashed line.

2. Select Go To from the Edit menu (shortcut: Ctrl+G), and type the name
of your unseen range in the Reference box, then press Enter. The range
will be selected.

3. Type the name of your unseen range in the Name box and press Enter.
The range will be selected.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

garnote wrote:

Hi all,

I have two two ranges (one column)
named mat1 and mat2.
I Choose Insert/Name/Define and
Name in Workbook: Three
Refers To: =mat1,mat2
I can utilize this new name for
my graphic but I can't see this
new range in my worksheet.
{=Three} don't work ?

Thanks,

Serge

Hi Jon,

Yes I know that :-) but ... :

Suppose that :
Name «mat1»:
1
2
Name «mat2»:
3
4
5
Name «Three» :
=mat1,mat2
I would like that «Three» appear in *one column* :
1
2
3
4
5

???

Serge



"Jon Peltier" a écrit dans le message de news:
...
Hi Serge -

Here are a few tricks.

1. In the Define Names dialog (shortcut: Ctrl+F3), select the name, then
click in the Refers To formula, and the range will be outlined with the
moving dashed line.

2. Select Go To from the Edit menu (shortcut: Ctrl+G), and type the name
of your unseen range in the Reference box, then press Enter. The range
will be selected.

3. Type the name of your unseen range in the Name box and press Enter.
The range will be selected.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

garnote wrote:

Hi all,

I have two two ranges (one column)
named mat1 and mat2.
I Choose Insert/Name/Define and
Name in Workbook: Three
Refers To: =mat1,mat2
I can utilize this new name for
my graphic but I can't see this
new range in my worksheet.
{=Three} don't work ?

Thanks,

Serge

Yep !

Sub Apparition()
Set joint = Range("Three")
For i = 1 To joint.Areas.Count
For Each c In joint.Areas(i)
j = j + 1
Cells(j, 2) = c
Next
Next i
End Sub

Serge


"garnote" a écrit dans le message de news:
...
Hi Jon,

Yes I know that :-) but ... :

Suppose that :
Name «mat1»:
1
2
Name «mat2»:
3
4
5
Name «Three» :
=mat1,mat2
I would like that «Three» appear in *one column* :
1
2
3
4
5

???

Serge



"Jon Peltier" a écrit dans le message de news:
...
Hi Serge -

Here are a few tricks.

1. In the Define Names dialog (shortcut: Ctrl+F3), select the name, then
click in the Refers To formula, and the range will be outlined with the
moving dashed line.

2. Select Go To from the Edit menu (shortcut: Ctrl+G), and type the name
of your unseen range in the Reference box, then press Enter. The range
will be selected.

3. Type the name of your unseen range in the Name box and press Enter.
The range will be selected.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

garnote wrote:

Hi all,

I have two two ranges (one column)
named mat1 and mat2.
I Choose Insert/Name/Define and
Name in Workbook: Three
Refers To: =mat1,mat2
I can utilize this new name for
my graphic but I can't see this
new range in my worksheet.
{=Three} don't work ?

Thanks,

Serge

Serge -

I assumed you were working with discontiguous ranges.

This turns ranges "one" and "two" into a single area, if they are
arranged as in your example:

Union(Range("one"),Range("two")).Select

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

garnote wrote:

Hi Jon,

Yes I know that :-) but ... :

Suppose that :
Name «mat1»:
1
2
Name «mat2»:
3
4
5
Name «Three» :
=mat1,mat2
I would like that «Three» appear in *one column* :
1
2
3
4
5

???

Serge



"Jon Peltier" a écrit dans le message de news:
...

Hi Serge -

Here are a few tricks.

1. In the Define Names dialog (shortcut: Ctrl+F3), select the name, then
click in the Refers To formula, and the range will be outlined with the
moving dashed line.

2. Select Go To from the Edit menu (shortcut: Ctrl+G), and type the name
of your unseen range in the Reference box, then press Enter. The range
will be selected.

3. Type the name of your unseen range in the Name box and press Enter.
The range will be selected.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

garnote wrote:


Hi all,

I have two two ranges (one column)
named mat1 and mat2.
I Choose Insert/Name/Define and
Name in Workbook: Three
Refers To: =mat1,mat2
I can utilize this new name for
my graphic but I can't see this
new range in my worksheet.
{=Three} don't work ?

Thanks,

Serge