Results 1 to 4 of 4

VBA: referencing subtotal in a EXCEL table

This is a discussion on VBA: referencing subtotal in a EXCEL table within the Excel Questions forums, part of the Question Forums category; Hi guys, I found this code that uses the tag #Header : Code: Range(TBL & "[[#Headers],[Column1]]").Select (where TBL is the ...

  1. #1
    New Member
    Join Date
    Nov 2016
    Posts
    12

    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,674

    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

    Default Re: VBA: referencing subtotal in a EXCEL table

    wonderful!
    thanks!

  4. #4
    MrExcel MVP
    Join Date
    Apr 2006
    Posts
    18,674

    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.

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
  •  


DMCA.com