Operation on a defined range

[rachexcel]

Hello,

I have a question about performing a mathematical operation on a range.

I have a defined range, say, range_1 containing a large number of values.

If I want to create a second range, 'range_2', which is just each value in range_1 + 5 (for example), how could I do this?

I just need to use the values temporarily in my VBA code so keeping them off the actual spreadsheet and completely in the code would be ideal.

Thanks,
Rach

 

[NeonRedSharpie]

Something like:

Dim rng as range
set rng = Worksheets("sheet name").Range("range_1")

Dim newVals() as double

For x = 1 to rng.row 'I don't think this will work but I can't test right now
     ReDim Preserve newVals(x)
     newVals(x) = rng(x) + 5
Next x