Matrix

G

garnote

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
 
J

Jon Peltier

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
 
G

garnote

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
 
G

garnote

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
 
Top