Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Newbie stuck on Passing a Variable into a Range | Excel Programming | |||
Newbie stuck on Passing a Variable into a Range | Excel Programming | |||
Newbie stuck on Passing a Variable into a Range | Excel Programming | |||
Newbie stuck on Passing a Variable into a Range | Excel Programming | |||
Passing a variable to a range statement | Excel Programming |