Named ranges cause error

[acroley1]

I have a form I've been building. The code that is throwing the error worked fine until I added some additional code...suddenly, I'm getting these crazy errors I've never seen before:

Errors.docx

Here is the form itself. I want to use the form "Shift Filled"...the error doesn't happen until I fill in some of the data and try to click the submit button.

Test.xlsm

I've used the code for the submit buttons a ton of times on different forms and never had this trouble. I've tried wiping out all of the submit buttons and their associated code and typing again and it gives me the same error.

Any suggestions? Thanks

[acroley1]

I forgot to mention I'm using Office 2013 on Windows 7

[acroley1]

Delete post

[acroley1]

Delete post

[acroley1]

Delete post

[acroley1]

Another update. I have elminated the automation error. HOWEVER, to do so I had to rebuild my data table. If I use "Name Manager - Create from selection" to name the columns of the table by the headers...the automation error comes back.

The thing is, I have formulas on the "Summary" tab that use the named ranges and I'm unsure of how to do this without named ranges. Any ideas on why a named range would cause an automation error? There are no links to outside data...this workbook is entirely self contained. This isn't use SQL (I don't even know what that is) or web queries (again...no clue) or anything like that...it's just a different tab in the same workbook.

Ideas/suggestions?

Also, my previous posts in this thread became irrelevant but I don't know if/how to delete them. I took out the body to eliminate confusion.