There is any way to use this code

Set rngArray = Range("xxx")
arrCodes = rngArray.Value

also for file csv?

I'd like to import into variant array a range from this kind of file.
Any idea?

tya

If you open a csv file in Excel like any other workbook, you can treat it as
a workbook, and do things such as that.

--
__________________________________
HTH

Bob

"JJF" wrote in message
...
There is any way to use this code

Set rngArray = Range("xxx")
arrCodes = rngArray.Value

also for file csv?

I'd like to import into variant array a range from this kind of file.
Any idea?

tya

On Oct 12, 6:13*pm, "Bob Phillips" wrote:
If you open a csv file in Excel like any other workbook, you can treat it as
a workbook, and do things such as that.

--
__________________________________
HTH

Bob

"JJF" wrote in message

...



There is any way to use this code

Set rngArray = Range("xxx")
* * * arrCodes = rngArray.Value

also for file csv?

I'd like to import into variant array a range from this kind of file.
Any idea?

tya- Hide quoted text -

- Show quoted text -


and how to import all range all at once into variatn variable?
cause it will get all the entire row, and i'd need the "split"