>>Is it possible to copy a range of cells (ex: A1:J1) to a VB array in 1 call?
>>
>>It is easy to copy a array to Excel range but how to read one?
>
>I looked and I cant find a way vice walking the collection in a function or similar. Sorry,

I found that you can declare a variable in VB as Range. I tried it but it looks that it is just a pointer to the Excel range.

The main reason to copy a range is for optimization (it is much faster to copy a array to Excel than to copy single cells). I wished I could revert this!