Automate 'fill formulas in tables to create calculated columns'

[supremesabre]

I need to automate the task of 'Overwrite all cells in this column with this formula' using a macro, on multiple files. However, this instruction does not get recorded with the macro recorder when I do it the manual way: typing the formula, clicking the drop down and selecting the 'Overwrite all cells...'.

Basically I want to achieve having formulas in each particular column auto-filling when I add rows to a table.

Anyone knows any vba instruction for me to perform this?

Thanks!

[xladept]

Here's a snippet that you may be able to adapt:

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

Where Cells(r, c).Resize(1, x) is the row with the Formulas

[supremesabre]

Thanks xladept... But I'm not sure how to implement the snippet =/

I uploaded a sample file showing this autofill problem. The table on the left does not autofill formulas when a row is added under 'barcode'. The table on the right works as I want. I need to make the left table autofill formulas...

Would greatly appreciate if you could point me in the right direction.

Thanks

[xladept]

For your sample:

Please Login or Register  to view this content.

[supremesabre]

Works great! Thank you! Have added your reputation.

[xladept]

You're welcome and thanks for the rep!