Hi all,
Here is my code, which does not generate the desired result:
Code
Dim c, rng As Range, i, j As Long, Txt1, Txt2 As String
i = Range("A" & Rows.Count).End(xlUp).Row
Txt1 = "E"
Txt2 = "G"
Set rng = Sheet1.Range("A2:A" & Sheet1.Cells(Rows.Count, "A").End(xlUp).Row)
For j = 2 To i
For Each c In rng
Cells(j, 9).Formula = "=" & Txt1 & j & Txt2 & j
Next c
Next j
The result, in J2 for example, is:
='E2'+'G2'
So, while the result is very close, I need to have the formula without the ' characters.
Any help would be appreciated!