C
Cornelius
Hi,
I need to create a macro that calculates a value based on several values in
a range. The result from the calculations shuld be copied into a new column
with the same range. I have tried to record this operation but I need help to
make the macro repeat the operations throug the range. I have pasted the code
from my recorded macro:
Range("B2").Select
ActiveCell.FormulaR1C1 = "=R[1]C[8]"
Range("C4").Select
ActiveCell.FormulaR1C1 = "=R[-1]C[6]"
Range("K3").Select
ActiveCell.FormulaR1C1 = "=R[11]C[-9]"
Range("L3").Select
ActiveCell.FormulaR1C1 = "=R[8]C[-10]"
End sub
I copy values from J3:J39 to be used in B2. Then I copy values from I3:I39
to be used in C4. From this i get two results that i want to be copied to new
columns in the same range. The results is genereted in cells B11 and B14, and
is copied into the range K3:K39 and L3:L39.
Thank you
Cornelius
I need to create a macro that calculates a value based on several values in
a range. The result from the calculations shuld be copied into a new column
with the same range. I have tried to record this operation but I need help to
make the macro repeat the operations throug the range. I have pasted the code
from my recorded macro:
Range("B2").Select
ActiveCell.FormulaR1C1 = "=R[1]C[8]"
Range("C4").Select
ActiveCell.FormulaR1C1 = "=R[-1]C[6]"
Range("K3").Select
ActiveCell.FormulaR1C1 = "=R[11]C[-9]"
Range("L3").Select
ActiveCell.FormulaR1C1 = "=R[8]C[-10]"
End sub
I copy values from J3:J39 to be used in B2. Then I copy values from I3:I39
to be used in C4. From this i get two results that i want to be copied to new
columns in the same range. The results is genereted in cells B11 and B14, and
is copied into the range K3:K39 and L3:L39.
Thank you
Cornelius