This is the line of code that's generating the formula,
worksheet.Cells(row, 13).R1C1Formula = "=R[" + CStr(row) + "]C*R[" + CStr(row) + "]C"
For the first time through the loop row = 3. So the expression evaluates to "=RC*RC". However, it converts this formula to "=Y7*Z7" instead of "=L4*M4".
At first I thought my freeze pane was causing the problem since I'm freezing 3 rows and the row was 3 off. However, turning it off had no effect. Also, I have no clue why the row is being sent way over to row Y.
Can someone help me figure this out?