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,
|