Partial Array into Excel Range

[eAlchemist]

I know how to assign a whole array to a range in Excel. Is there a way to assign a contiguos range of values within an array into a range of cells? I know that I can do it with a loop, but I'm wondering if I can do it in one line.

Thanks,
Chris

 

[SkipVought]

Hi,

One line...

for i=0 to ubound(a):cells(i+1,"A").value = a(i):next

Skip,
[sub]
[red][/red]
[/sub]

 

[GlennUK]

I know how to assign a whole array to a range in Excel.

How do you do that exactly? If you do a simple assignment you will end up with a 2 dimensional array. To put the same size of array back just reverse the assignment statement.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.