VBA Code using RC

[gnt21]

Very new to VBA and unsure what the code is supposed to return. So I'm looking for experts help to say in plain english what should be returned in this scenario:

BookA.Sheets("Results").Range("AE2").FormulaR1C31 = "=TRIM(RC[" & Rein_Trty_Col - 1 & "])"

I'm trying to alter an existing workbook to handle a new situation. I really appreciate any help. Thanks!

 

[6StringJazzer]

Your code should be

FormulaR1C1

not

FormulaR1C31

You have not told us the meaning of variable Rein_Trty_Col. The way it is used here, the [brackets] indicate that it is a relative column reference. If Rein_Trty_Col is 10, for example, the resulting R1C1 formula will be
=TRIM(RC[9])
That means "same row as the cell with this formula, and 9 columns to the right"

You are putting this formula in AE2, so that example formula will look like this once it is put in the cell:

=TRIM(AN2)

In reality AN is going to be whatever column that is (Rein_Trty_Col - 1) columns to the right of column AE.

 

[gnt21]

Much appreciated. Now I know what to be looking for and how to adjust as needed.