>>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!
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com