Formulas

[Matt5353]

I have a column with 8000 rows.
In row 8001 I have a sum formula to add the total in the column.
I have created a macro to create another column.
How can I get the formula added to the new column automatically?
Andrew

 

[BigBeachBananas]

Just use autofill?

 

[Matt5353]

Thanks
Yes I could
But when I'm creating a new column with my macro I want the formula at the bottom of my sheet to copy at the same time
automatically

 

[BigBeachBananas]

Thanks
Yes I could
But when I'm creating a new column with my macro I want the formula at the bottom of my sheet to copy at the same time
automatically

Do you have the macro? I can't help without seeing the macro.

 

[Matt5353]

Yes.

Sub New_Column()
'
' Add_New Column Macro
'
Range("M1").EntireColumn.Insert

End Sub