+ Reply to Thread
Results 1 to 2 of 2

Deleting table (listobject) range without activating

  1. #1
    Forum Contributor
    Join Date
    09-17-2014
    Location
    UK
    MS-Off Ver
    2007
    Posts
    117

    Deleting table (listobject) range without activating

    I'm deleting a selection of rows and columns from a listobject and can successfully delete columns without activating but not rows.

    The code is:
    Please Login or Register  to view this content.
    Is there a way around activating the sheet first?

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Deleting table (listobject) range without activating

    This should work without activating the sheet. It does with me.
    How is this object lst defined?
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Cycle through all records in a table listobject
    By Smally in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-12-2016, 05:03 PM
  2. [SOLVED] Code help: Update new row of Table (ListObject) via UserForm
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-27-2015, 04:11 AM
  3. [SOLVED] Get Cursor Location in a ListObject table
    By snapfade in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2014, 05:24 PM
  4. [SOLVED] Converting Query Table to ListObject
    By x10sion in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-04-2013, 06:56 AM
  5. Remove Filter From ListObject Table
    By efernandes67 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2011, 04:47 AM
  6. Table ListObject Filter
    By efernandes67 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-23-2011, 07:40 AM
  7. deleting charts without activating them
    By cuewoz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2007, 12:38 PM

Tags for this Thread

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