Help converting formula to VBA

[cspengel]

I've been struggling with this for a full day and it is driving me insane. I am a new to this and I cannot get this formula to work for the life of me. I have a feeling it may be due to certain parenthesis, but not sure. I keep getting a VALUE!# error.

Formula: =TEXTJOIN(" , ",1,IF(AM2:AU2=AX2,AM1:AU1,""))
Recorded macro and got this: .FormulaR1C1 = "=TEXTJOIN("","",1,IF(RC[-12]:RC[-4]=RC[-1],R[-1]C[-12]:R[-1]C[-4],""""))"

The columns are dynamic or could change. I was trying to start with the basics and see if I could get any formula to work. Please help. I am lost.

 

[Fluff]

Hi & welcome to MrExcel.
You need to use Formula2R1C1 rather than FormulaR1C1
Also you will probably need to lock the first row like

.Formula2R1C1 = "=TEXTJOIN("","",1,IF(RC[-12]:RC[-4]=RC[-1],R1C[-12]:R1C[-4],""""))"

 

[cspengel]

Hi & welcome to MrExcel.
You need to use Formula2R1C1 rather than FormulaR1C1
Also you will probably need to lock the first row like

.Formula2R1C1 = "=TEXTJOIN("","",1,IF(RC[-12]:RC[-4]=RC[-1],R1C[-12]:R1C[-4],""""))"

Wow thank you so much for the quick solution! You are a true blessing.

 

[Fluff]

You're welcome & thanks for the feedback.