Coverting single-value array into an ordinary variable
 

Dear all,

I have a single-valued array X (i.e., its dimensions is 1-by-1) which holds
an integer. Is there an easy way of converting it back to an ordinary
integer variable? Thanks a lot.

Frederick Chow
Hong Kong

Coverting single-value array into an ordinary variable
 

If you don't know how the array is dimensioned, you could do something like:

Dim myArr(7 To 7, 19 To 19) As Long
Dim myNumber As Long
myArr(7, 19) = 123 'assign it someway
myNumber = myArr(LBound(myArr, 1), LBound(myArr, 2))
MsgBox myNumber

If you knew the array dimensions:

Dim myArr(1 To 1, 1 To 1) As Long
Dim myNumber As Long
myArr(1,1) = 789 'assign it someway
myNumber = myArr(1, 1)
MsgBox myNumber

Fred Chow wrote:

Dear all,

I have a single-valued array X (i.e., its dimensions is 1-by-1) which holds
an integer. Is there an easy way of converting it back to an ordinary
integer variable? Thanks a lot.

Frederick Chow
Hong Kong

--

Dave Peterson

Coverting single-value array into an ordinary variable
 

Thanks a lot.

At least I know that there is no simple way of doing the job. Thanks.

Frederick Chow
Hong Kong.

"Dave Peterson" wrote in message
...
If you don't know how the array is dimensioned, you could do something
like:

Dim myArr(7 To 7, 19 To 19) As Long
Dim myNumber As Long
myArr(7, 19) = 123 'assign it someway
myNumber = myArr(LBound(myArr, 1), LBound(myArr, 2))
MsgBox myNumber

If you knew the array dimensions:

Dim myArr(1 To 1, 1 To 1) As Long
Dim myNumber As Long
myArr(1,1) = 789 'assign it someway
myNumber = myArr(1, 1)
MsgBox myNumber

Fred Chow wrote:

Dear all,

I have a single-valued array X (i.e., its dimensions is 1-by-1) which
holds
an integer. Is there an easy way of converting it back to an ordinary
integer variable? Thanks a lot.

Frederick Chow
Hong Kong

--

Dave Peterson