How can I turn off calculated columns in an Excel table from a macro using VBA? [migrated]
- by user41293
I am working on a macro that inserts formulas into a cell in an Excel table.
The Excel table does the automatic filling of columns and fills all the cells in that column with the formula, but all I want is one cell to have the formula. I cannot just turn off automatic formula for tables as I need to have other people use this worksheet on their systems.
Is there a way to turn off the automatic filling of formulas in a table using VBA in a macro? It just needs to be temporary: I just want to turn it off, put in my formulas, then turn it back on.
