![]() |
|
#1
|
|||
|
|||
![]()
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:
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) |
![]() |
Tags |
vba excel |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
MS Outlook 2007 Search Not Working | Harry Rolnick | Outlook | 1 | 04-06-2016 12:59 PM |
Excel error window: Excel has stopped working | MunganBrus | Excel | 1 | 01-13-2015 11:19 AM |
How can I fix a print view problem that causes it to stop working.. Excel 2007, Vista | birdie123 | Excel | 0 | 08-18-2012 12:02 PM |
Excel 2007 to Word 2007 Labels mail merge not working | rec | Mail Merge | 0 | 07-31-2010 10:45 AM |
![]() |
jbiggs | Office | 1 | 02-12-2009 09:02 AM |