Get the Listobject Range without the Sheet Specification

Question

I have multiple tables in the workbook in different sheets. All the tables scope is Workbook as can be seen in the pic.

Using VBA, is there a way to get this object assign to a ListObject variable without defining the SheetName?

Answer 1

If I got you right and according to your screenshot you could use the following code for tblStage

Dim lo As ListObject    
Set lo = Range("tblStage").ListObject

Reading material 1 2