View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Doug R Doug R is offline
external usenet poster
 
Posts: 1
Default 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,