Passing information from VBA variable to Excel range
 

I am new to this - sorry for the basic question.
First I grab a range of data from excel and put it in a variant by:
variant_matrix = Range("A1:B100").Value

then do a whole bunch of manipulation in vba,
now I want to pass the variable back to excel in the range("C1:D100")
is there a way to do this efficiently? The only way I have found that works is
to use a loop and do it cell by cell which is very time consuming.
Is there an equivalent to:

Range("C1:D100").Value = variant_matrix


Thank you,

Passing information from VBA variable to Excel range
 

That is it

Range("C1:D100").Value = variant_matrix

--
Regards,
Tom Ogilvy

"Doug R" wrote in message
om...
I am new to this - sorry for the basic question.
First I grab a range of data from excel and put it in a variant by:
variant_matrix = Range("A1:B100").Value

then do a whole bunch of manipulation in vba,
now I want to pass the variable back to excel in the range("C1:D100")
is there a way to do this efficiently? The only way I have found that
works is
to use a loop and do it cell by cell which is very time consuming.
Is there an equivalent to:

Range("C1:D100").Value = variant_matrix


Thank you,