All I have to go by is
the file you posted and
it does not have a table named "mt".
Table1 is the default name Excel gave to the table at the time it was created, I suspect you tried to rename it and in the process created the named range "mt".
Click the drop down arrow in the Name Box above column A, you'll see both mt and Table1.
Selecting each of them, you'll see they are not the same, one includes row 1 and one doesn't.
Quote:
|
how can I do it without giving the table a name?
|
you could refer to the first table on a sheet as .ListObjects(1)
Here's a couple of links to sites with info on Excel Tables:
The VBA Guide To ListObject Excel Tables — The Spreadsheet Guru
Excel: Working with Tables (VBA)