Results 1 to 6 of 6

deleting Column Headers

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-27-2020
    Location
    Rotterdam, The Netherlands
    MS-Off Ver
    2013
    Posts
    447

    deleting Column Headers

    I would like te have a macro that deletes the table headers in range(I1:L1) of the table. I referred to the table as listobjects(1). I don't know if this is the right way to do it.
    How can i do this?

    Any input is much appreciated!

    Sub testdeleteheaders()
    
    Dim tbl As ListObject, sh As Worksheet
    Set tbl = ListObjects(1)
    Set sh = Worksheets("info88")
    
            tbl.Range("I1:L1").ClearContents
    End Sub
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Filter Data Set using Row Headers in lieu of Column Headers
    By bsnell in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-30-2019, 11:43 AM
  2. Replies: 1
    Last Post: 02-03-2016, 02:33 AM
  3. [SOLVED] listbox with column headers as a specific sheet column headers
    By ANDREAAS in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-07-2014, 04:40 AM
  4. deleting columns with headers not contained in a list
    By excelfuchs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2013, 10:11 AM
  5. Replies: 3
    Last Post: 09-11-2012, 02:19 AM
  6. Replies: 2
    Last Post: 05-09-2012, 01:30 PM
  7. comparing the column headers, then deleting the entire column iif duplicates occur
    By vindieselgal in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-25-2011, 04:53 AM

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