[column(101:200)] confusing
 

Hi all,

[Row(101:200)] will produce two dimension array, 100 rows and 1 column,
containg values from101 to 200. How about [column(101:200)]?

Clara
--
thank you so much for your help

[column(101:200)] confusing
 

Are you trying to pick up a 65536 row x 100 column array:

Dim a As Variant
a = Columns(101).Resize(, 100).Value

(in xl2007, this is 1MB rows)

clara wrote:

Hi all,

[Row(101:200)] will produce two dimension array, 100 rows and 1 column,
containg values from101 to 200. How about [column(101:200)]?

Clara
--
thank you so much for your help

--

Dave Peterson

[column(101:200)] confusing
 

Same thing except:

column(101:200)

produces 1 row, 100 columns

One goes vertical, the other horizontal.

"clara" wrote:

Hi all,

[Row(101:200)] will produce two dimension array, 100 rows and 1 column,
containg values from101 to 200. How about [column(101:200)]?

Clara
--
thank you so much for your help