2 named cells
 

Just currious.
If I wanted to put 2 different named cells on a single cell. I use named
cells to exchange information to other programs.

I would not think this can be done. Haveing 2 different named cells.
Would there be a way to trick excel into allowing something like this? Has
anyone thought about this problem?

thanks for any input

2 named cells
 

Let's say we have named A1 alpha and named A2 beta, then in A3 enter:

=alpha & beta
--
Gary''s Student - gsnu2007i


"greg" wrote:

Just currious.
If I wanted to put 2 different named cells on a single cell. I use named
cells to exchange information to other programs.

I would not think this can be done. Haveing 2 different named cells.
Would there be a way to trick excel into allowing something like this? Has
anyone thought about this problem?

thanks for any input

2 named cells
 

I assume that we are talking about named ranges. If so then two different
named ranges can refer to the same cell or range of cells.

Insert - Name - Define - Add two different named ranges that both
reference the same cell.
--
HTH...

Jim Thomlinson


"greg" wrote:

Just currious.
If I wanted to put 2 different named cells on a single cell. I use named
cells to exchange information to other programs.

I would not think this can be done. Haveing 2 different named cells.
Would there be a way to trick excel into allowing something like this? Has
anyone thought about this problem?

thanks for any input

2 named cells
 

Hi Greg,

How about ten names:

'==========
Public Sub Tester()
Dim WB As Workbook
Dim SH As Worksheet
Dim rng As Range
Dim i As Long
Const sStr As String = "Piggy"

Set WB = ThisWorkbook
Set SH = WB.Sheets("Sheet1")
Set rng = SH.Range("A1")

For i = 1 To 10
WB.Names.Add Name:=sStr & i, _
RefersTo:=rng.Address
Next i
End Sub
'<<==========


---
Regards.
Norman


"greg" wrote in message
...
Just currious.
If I wanted to put 2 different named cells on a single cell. I use named
cells to exchange information to other programs.

I would not think this can be done. Haveing 2 different named cells.
Would there be a way to trick excel into allowing something like this?
Has anyone thought about this problem?

thanks for any input

2 named cells
 

thanks all.


"greg" wrote in message
...
Just currious.
If I wanted to put 2 different named cells on a single cell. I use named
cells to exchange information to other programs.

I would not think this can be done. Haveing 2 different named cells.
Would there be a way to trick excel into allowing something like this?
Has anyone thought about this problem?

thanks for any input