I assume i is your variable, you need to put it outside of a string for Excel to recognize it's a variable.
![]()
ActiveCell.FormulaR1C1 = "=offset(Summary!R[4]C[2],25*" & i & ",0)"
I assume i is your variable, you need to put it outside of a string for Excel to recognize it's a variable.
![]()
ActiveCell.FormulaR1C1 = "=offset(Summary!R[4]C[2],25*" & i & ",0)"
多么想要告诉你 我好喜欢你
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks