Jeffrey Mahoney
Well-known Member
- Joined
- May 31, 2015
- Messages
- 2,804
- Office Version
- 365
- Platform
- Windows
I'm starting to see the value of using Excel Tables rather than dynamic named ranges. I know I can get ranges and headers from the table by direct reference. How do I get the name of the current Table?
I have 3 sheets, each with an Excel Table laid out with the exact same headers. Open Items, Approved Items, Completed Items. Lots of Sheet triggers are built in and I need to know what table name is from the target cell.
So I can use it like this:
[/Quote]
I have 3 sheets, each with an Excel Table laid out with the exact same headers. Open Items, Approved Items, Completed Items. Lots of Sheet triggers are built in and I need to know what table name is from the target cell.
So I can use it like this:
VBA Code:
TblName = CurrentTable <<<< Unknown
Set R = Range(TblName & "[[Quote]:[Doc]]"
VBA Code:
Sub Macro9()
Dim R As Range
Range("ApprovedItems_tbl[[Quote]:[Doc]]").Select
Set R = Range("ApprovedItems_tbl[[Quote]:[Doc]]")
End Sub