Help to create a macro

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
 
D

Dave D-C

.. I copy values from J3:J39 to be used in B2 ..
Be more specific on this. Say it in a different way. Dave D-C

Cornelius said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top