VBA help: need to transfer 130 cells to memory and back

[waeltken]

Hello,

I am very new to VBA and am trying to write a simple procedure which will "record" the formulas from 130 adjacent cells (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

[RonMcK]

-waeltken,

It would help everyone here if you would post of workbook showing what you've accomplished so far, including a page of your original data and formulas and a second showing what you want the final result (output) to look like.

Thanks,