A sample spreadsheet so we can see the data in the spreadsheet will likely be very helpful in visualizing what you are wanting to go into what element of the array.
Note that this syntax:
arReport(intTblCtr) = tbl.Name
'or
arReport(intTblCtr, intRowCtr) = tbl.DataBodyRange.Row
is invalid. arReport is a 3D array, so any assignment statement must reference a single element using all three indices. It is not clear to me exactly where in the array you want to store these pieces of information, but your assignment statement must refer to a single element:
arReport(intTblCtr,0,0)=tbl.Name
or
arReport(intTblCtr,intRowCtr,0)=tbl.DataBodyRange.Row
Bookmarks