+ Reply to Thread
Results 1 to 3 of 3

Tables and clear format in worksheet

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,942

    Tables and clear format in worksheet

    Hi,

    i have a lot of listobjects in one worksheet and what want to achevie is to clear formats from them.

    I recorded macro:

        Selection.ClearFormats ''here i am selecting whole worksheet
        ActiveSheet.ListObjects("t_Ips").TableStyle = ""
        ActiveSheet.ListObjects("t_DnsSource").TableStyle = ""
        ActiveSheet.ListObjects("t_SharedStorages").TableStyle = ""
        ActiveSheet.ListObjects("t_Subnets").TableStyle = ""
        ActiveSheet.ListObjects("t_ResourceGroups").TableStyle = ""
        ActiveSheet.ListObjects("t_TierAutomations").TableStyle = ""
    But you can see for each listobject there is separeted statement. It is possible to do it in one command?

    Best,
    Jacek

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,320

    Re: Tables and clear format in worksheet

    You can just loop
    For each lo in activesheet.listobjects
    lo.tablestyle = ""
    next
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,942

    Re: Tables and clear format in worksheet

    thank you Rorya very much for help!

    Jacek

+ 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. [SOLVED] Clear data fom multiple tables
    By DeanMcK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2019, 07:39 PM
  2. Clear many empty tables of data
    By salmasaied in forum Excel Programming / VBA / Macros
    Replies: 42
    Last Post: 11-22-2016, 06:12 PM
  3. Clear Contents specific range of many tables
    By salmasaied in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-05-2016, 04:01 PM
  4. [SOLVED] Clear all filters (tables) on multiple worksheets
    By lucasreece in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-26-2015, 07:30 AM
  5. Formatting a worksheet of raw data tables with same format automatically
    By letstuffhappen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2015, 11:29 AM
  6. Clear Pivot Tables
    By rbirch in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-03-2015, 11:35 PM
  7. [SOLVED] pivot tables:clear summary
    By Josie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-24-2006, 03:20 PM

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