"muster" wrote in message
oups.com...
I use variant array (ie. dim array as variant) to read a range from a
sheet into to an array to avoid loops.

I found the array is always 2D, even when I read a single row or
column. Is there a way (or another way if I did wrong) to make it 1D
array?

That is right, because a range has rows and columns, so it always allows for
multiples


Further more, is it possible to get single row or column from this kind
of 2D array quickly, like array(1) or array(1, *)?

Don't think so, you need to loop through if you want it single dimension.