How to write a Table Reference in VBA
Posted on 2010-11-23
In Excel 2007, the program has greatly expanded the capability of Tables. There have a number of articles and snippets of code that reference Table columns and if the row happens to be known, the possibility of using [#This Row]. I haven't yet seen something that references a Table Column(#Header] Name with the lLastRow of the Table.
Is there a way of accurately forming a statement that can incorporate both pieces of a Table as a reliable reference point that can be used within VBA? This would be without having to run a separate lLastRow statement, and then using that to somehow piece together the cell reference of the lLastRow and Table Column Name? Somehow it would seem there should be a:
method of finding the cell reference at that intersection.