Named range in an array
 

Hi,

I have five cells on a row (A1:A5). This range is named "xyz".
How can I transform this range in an array with VB code?

Thank you.
Paolo.

Named range in an array
 

dim v as Variant
v = Range("xyz").Value

for i = 1 to 5
msgbox v(i,1)
Next


If you want a 1D array

v = application.Transpose("xyz")

for i = 1 to 5
msgbox v(i)
Next

--
Regards,
Tom Ogilvy


"Frigster" wrote:

Hi,

I have five cells on a row (A1:A5). This range is named "xyz".
How can I transform this range in an array with VB code?

Thank you.
Paolo.

Named range in an array
 

Tom Ogilvy wrote:
dim v as Variant
v = Range("xyz").Value

for i = 1 to 5
msgbox v(i,1)
Next


If you want a 1D array

v = application.Transpose("xyz")'<---A typo:v = application.Transpose(Range("xyz"))

for i = 1 to 5
msgbox v(i)
Next

Alan Beban

Named range in an array
 

Sorry, I think there is again a typo ...

If you want a 1D array
v = application.WorkSheetFunction.Transpose(Range("xyz "))

Christian CROCHE

Named range in an array
 

No, there is no requirement to use WorksheetFunction. No typo.

--
Regards,
Tom Ogilvy


"ccroche" wrote in message
...
Sorry, I think there is again a typo ...

If you want a 1D array
v = application.WorkSheetFunction.Transpose(Range("xyz "))

Christian CROCHE

Named range in an array
 

One way:

Dim arr As Variant
arr = Range("A1:A5").Value


In article ,
"Frigster" wrote:

Hi,

I have five cells on a row (A1:A5). This range is named "xyz".
How can I transform this range in an array with VB code?