Hi,
Please assist me. I have attached a sample file.
I am using the following code to insert a column and copy formulas.
This inserts a column but does not include the formulas in the header row and total row. Also the total column does not include the new column in it's sum calculation. Please help me, I greatly appreciate it.
The code I have for inserting a row works fine however it copies the row above - I would like it to copy only the formulas.
Please assist me. I have attached a sample file.
I am using the following code to insert a column and copy formulas.
Code:
Sub InsertColumn()
ActiveCell.Offset(-1, 0).EntireColumn.Insert
ActiveCell.EntireColumn.Copy ActiveCell.Offset(-1, 0).EntireColumn
End Sub
This inserts a column but does not include the formulas in the header row and total row. Also the total column does not include the new column in it's sum calculation. Please help me, I greatly appreciate it.
The code I have for inserting a row works fine however it copies the row above - I would like it to copy only the formulas.