VBA: How do I change this cell reference into a Formula?

[Peter h]

I'm trying to change the highlighted Cell reference into a formula, so that it is dynamic and changes as the data changes, and not just when the macro is run. Does that make sense? So the macro will write the formula (...Cell = "=...")

lCol = ws.Cells(1, Columns.Count).End(xlToLeft).Column

i = Me.lb_Players.ListIndex + 1
j = Me.lb_Rounds.ListIndex + 1
k = Me.lb_Opp.ListIndex + 1

ws.Cells(i + 1, (lCol + j) + Me.lb_Rounds.ListCount) =[COLOR=#FF0000] ws.Cells(k + 1, lCol - 1).Value[/COLOR]

 

[V_Malkoti]

To write the cell reference:

ws.Cells(i + 1, (lCol + j) + Me.lb_Rounds.ListCount).Formula = ws.Cells(k + 1, lCol - 1).Address

 

[=ODIN=]

Try

[COLOR=#333333]ws.Cells(i + 1, (lCol + j) + Me.lb_Rounds.ListCount).[U]formula[/U] = "=" & [/COLOR][COLOR=#FF0000] ws.Cells(k + 1, lCol - 1).[U]address[/U][/COLOR]

 

[Peter h]

Thank you both for the response. I don't know why I didn't think of that. I think I was overthinking it. lol.