Dynamically select List Object name

**Norie** · 05-14-2013, 04:55 PM

Have you checked the names of the tables on worksheet 'DB'.?

This small bit of code will print them all out to the Immediate Window (CTRL+G), along with their address so you can locate them.

Sub ListTables()
Dim lst As ListObject

    For Each lst In Worksheets("DB").ListObjects
        Debug.Print lst.Name & " - " & lst.DataBodyRange.Address
    Next lst

End Sub

**escobf** · 05-14-2013, 05:28 PM

I actually just did that and found I had the ListColumn name incorrectly (it is "Assets" in my actual workbook). Luckily I am too tired to want to break something but at least my issue is finally resolved!!

Thanks for your help Norie.

**escobf** · 05-14-2013, 05:29 PM

I actually just did that and found I had the ListColumn name incorrectly (it is "Assets" in my actual workbook). Luckily I am too tired to want to break something but at least my issue is finally resolved!!

Thanks for your help Norie.