Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Get the Listobject Range without the Sheet Specification

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

Table list in the workbook

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

like image 414
Arya Avatar asked Sep 03 '25 06:09

Arya


1 Answers

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

like image 64
Storax Avatar answered Sep 04 '25 23:09

Storax