Stop AutoFillFormulas in Specific Data Table Column

[baseball17bucks]

Hi - is there a way to get the "AutoFillFormulas" property to be turned off for a specific column(s) in a Data Table? My table is called "Cash_Analysis_Revised" and I want the formulas to stop auto-filling just for that specific column.

I tried the macro below, but I get the 438 error shown.

 

[Joe4]

I am sure someone will correct me if I am wrong, but I don't know if that is possible, and kind of defeats the whole purpose of using tables.
In tables, all the rows are consistent. If there is a formula in a certain column, every row in that column has a formula.
The advantageous thing about it is if you add new rows, you do not need to explicitly add the formulas. They are automatically extended due to the nature of the table.

If you want formulas in some rows of a column, but not all, I think you probably should not be using a table, and should just be using a data list instead.

 

[baseball17bucks]

I hope someone corrects you! Thanks though for the time being.

 

[baseball17bucks]

Solution from a colleague - it works!!!