Good Day Experts!
I am having a bit of trouble here trying to figure out my SUM formula using variable for the column. I can figure it out with a variable for the row end.
This works if I hard code the Column:
oSheet.Cells(DataRow + 2, ColumnStart).Formula = "=SUM(C7:C" & (DataRow) & ")"
Is it possible to use variable on Column reference?