Matrix

  • Thread starter Thread starter garnote
  • Start date Start date
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
 
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
 
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
 
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
 
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
 
Back
Top