Hello,
I am very new to VBA and am trying to write a simple procedure which will "record" the formulas from 130 adjacent (dimensions: 1 row, 130 columns) to memory.
Then I want to multiply all the formulas by a factor, record the change in an output variable and finally replace the altered 130 cells with the original formulas.
I have figured out how to perform the multiplication, and get the readout values, but how do I assign 130 cells to a variable? Or do I need to use an array for this? Also, what is the syntax to assign and then retrieve the contents of these cells to "memory" (variable or array).
Please help!
-waeltken
I am very new to VBA and am trying to write a simple procedure which will "record" the formulas from 130 adjacent (dimensions: 1 row, 130 columns) to memory.
Then I want to multiply all the formulas by a factor, record the change in an output variable and finally replace the altered 130 cells with the original formulas.
I have figured out how to perform the multiplication, and get the readout values, but how do I assign 130 cells to a variable? Or do I need to use an array for this? Also, what is the syntax to assign and then retrieve the contents of these cells to "memory" (variable or array).
Please help!
-waeltken