Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: VBA: referencing subtotal in a EXCEL table

  1. #1
    New Member
    Join Date
    Nov 2016
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default VBA: referencing subtotal in a EXCEL table

    Hi guys,
    I found this code that uses the tag #Header:

    Code:
    Range(TBL & "[[#Headers],[Column1]]").Select
    (where TBL is the table name)

    By google I also discovered the tags #All and #Data.

    Are there other useful tags like these one?
    It would be very useful for my needs a tag to select the total and subtotals. I tried #Totals and #Subtotals but they don't work.

    Where could I found a list of all the available tags to be used on a listobject table?

    thanks
    Last edited by Gringoire; Apr 21st, 2017 at 06:08 AM.

  2. #2
    MrExcel MVP
    Join Date
    Apr 2006
    Posts
    18,856
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA: referencing subtotal in a EXCEL table

    Hi

    The article about structured references from microsoft:

    https://support.office.com/en-us/art...3-c8ae6d2b276e
    Kind regards
    PGC

    To understand recursion, you must understand recursion.

  3. #3
    New Member
    Join Date
    Nov 2016
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA: referencing subtotal in a EXCEL table

    wonderful!
    thanks!

  4. #4
    MrExcel MVP
    Join Date
    Apr 2006
    Posts
    18,856
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA: referencing subtotal in a EXCEL table

    You're welcome

    Quote Originally Posted by Gringoire View Post
    Where could I found a list of all the available tags to be used on a listobject table?
    Remark: it's good to know how to work with structured references but in vba, like the case you posted, I'd rather use the object properties/methods.
    Kind regards
    PGC

    To understand recursion, you must understand recursion.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.
     


DMCA.com