adding data to new column
I am using this to insert a column:
myRng.Offset(0, Res + 1).EntireColumn.Insert
How can I make cell (<NewCol33) have the value
"=SUM(<newcol2:<newcol32)" ?
ie: if the new column is Column C, I would like cell C33 to be
"=SUM(C2:C32)"
Thanks!
|