Hi all,

Here is my code, which does not generate the desired result:

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!

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

='E2'+'G2'

So, while the result is very close, I need to have the formula without the ' characters.

Any help would be appreciated!

## Comment