+ Reply to Thread
Results 1 to 2 of 2

Disable "Include new rows and columns in table"

  1. #1
    Registered User
    Join Date
    11-05-2010
    Location
    Over, There
    MS-Off Ver
    Excel 2016
    Posts
    44

    Disable "Include new rows and columns in table"

    I've been searching for about 2 hours now and can't figure out how to disable "Include new rows and columns in table" with VBA. I have a table and values are added next to the table so excel likes to make the table bigger. I don't want this, I also don't want to have to manually disable this every time. How can I disable this with VBA then re-enable it after the values are added?

  2. #2
    Registered User
    Join Date
    11-05-2010
    Location
    Over, There
    MS-Off Ver
    Excel 2016
    Posts
    44

    Re: Disable "Include new rows and columns in table"

    Forgot about the Record Macro button .

    "Application.AutoCorrect.AutoExpandListRange = True" is what I was looking for

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1