range array

[JJF]

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

 

[Bob Phillips]

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.

 

[JJF]

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

--
__________________________________
HTH

Bob










- 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"