Macro recording

[Dolemitefunk]

I am trying to create a macro that will open anther workbook, select the sheet, go to a specific cell and set that cell equal to the original worksheet the marco is being made on. I have tried to create this by recording and have a few questions about the code.

ActiveCell.FormulaR1C1 = "='[Testing.xlsm]Sheet1'!R[12]C[-5]"

I do not understand what this line is doing, it looks like it is selecting the cell by moving it from a reference point, how would I make it so it picks a specific cell?

I hope this makes sense, any feedback would be greatly appreciated

 

[auto.pilot]

When recording a macro, you have a choice of using relative references. I use XL 07 and can click the 'Use Relative References' button after starting to record the macro. The line you have is a reference to the row and column of the cell you selected in the file called Testing. It may help to record the macro without Relative References option selected.

ActiveCell.FormulaR1C1 = "='[Testing.xlsm]Sheet1'!R[12]C[-5]"

 

[Dolemitefunk]

Thank you for the advice, I will try it again ....Much Appreciated!

 

[Dolemitefunk]

ActiveCell.FormulaR1C1 = "='[Testing.xlsm]Sheet1'!R[17]C[-5]"

I tried recording the macro again, and got this same line. I made sure the reference button was off. Is there a way to change this code to pick Cell C31 in the Testing.xlsm Worksheet?

 

[auto.pilot]

Sorry I sent you in the wrong direction yesterday. The formula within the macro will always use the R1C1 reference. However, if you'd like the formula to always appear in a specific cell, the following may help:

Cells.Range("A3").FormulaR1C1 = "=R[-2]C+R[-1]C"

This line of code will insert the formula =A1+A2 into cell A3

Hope this helps.

jim