'How to not automatically include an inserted excel column in an adjacent table using VBA?

I hope this is an easy question and solution, but I couldn't find anything on how to "temporarily" turn off the "including new rows and columns in table" I know that in the Excel options in Proofing there's a checkbox just for this, but can this be controlled within a VBA macro?

I'm a newbie so please be nice :)

Thanks!

excel vba

Solution 1:^[1]

In VBA the syntax is

 Application.AutoCorrect.AutoExpandListRange = False

and you would replicate that line, with True instead, when you wanted to re-enable it.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Spectral Instance

'How to not automatically include an inserted excel column in an adjacent table using VBA?

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]