+ Reply to Thread
Results 1 to 2 of 2

Deleting all rows in Named Table

  1. #1
    Registered User
    Join Date
    05-12-2010
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    42

    Deleting all rows in Named Table

    Hey folks,

    I have a named table (“Table_Sites”) with one column and I want to delete all rows of the table with the exception of the header.

    I want to incorporate this as part of a process where the content get cleared out and then new values get inputted at the end of the process.

    I do have other tables on the same sheet to the right of this table so I can’t use a “Sheets(“XX”).EntireRow.Delete” function. I simply want to delete all contents using something similar to:

    Please Login or Register  to view this content.

    I’m just not sure what the correct syntax would be. Thanks in advance.
    Last edited by LampCommandr; 07-26-2011 at 03:46 PM.

  2. #2
    Registered User
    Join Date
    05-12-2010
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: Deleting all rows in Named Table

    Figured it out. For anyone that might need the information, I used the following:

    Please Login or Register  to view this content.

+ 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