Hello Everyone,
When I record a macro while creating a formula, I get the following:
Code
ActiveCell.FormulaR1C1 = _"=CONCATENATE(""T"",""QQQQ"",""_"",RIGHT(RC[3],3),""_"",RIGHT(RC[4],3))"
Variable Qcode = "QQQQ"
Variable myString = """T"",""QQQQ"",""_"",RIGHT(RC[3],3),""_"",RIGHT(RC[4],3)"
I have searched the forums and tried different ways to use this in a macro all to no avail
I have tried:
Results in error
Results #NAME (=CONCATENATE(myCombo)) in cell
And also creating another string variable for the entire thing:
myString2 = "=CONCATENATE(""T"",""QQQQ"",""_"",RIGHT(RC[3],3),""_"",RIGHT(RC[4],3))"
Results in an error
I am missing something, but I don't know exactly what.
Any and all help is greatly appreciated.