Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding digits in a column based on data in a separate column | Excel Discussion (Misc queries) | |||
Adding column data based on match in 2nd column - Help | Excel Worksheet Functions | |||
Removing one column of data and adding another column | Excel Discussion (Misc queries) | |||
Adding data to existing data that has a unique number in column | Excel Discussion (Misc queries) | |||
Adding column data | Excel Worksheet Functions |