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

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

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

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

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