Subscript out of range

[wpryan]

Hello,



I developed an Access database which is using a Excel spreadsheet as its input. The spreadsheet has 6 named ranges which correspond to the tables in the database. After importing the first named range, and when trying to import the next named range I always get a "Subscript out of range" error. I looked for any kind of formatting error, including of course number formats, incorrect spelling etc. I have found from experience that simply closing Access after importing the first named range, and then opening it again I can continue without problem. This problem isn't preventing me from working but is annoying. Any hints about how to solve this?

...cross posted here: http://www.utteraccess.com/forum/ind...wtopic=2033024

[orange]

Show us some code.

[wpryan]

Thanks for your reply. There is no code. I'm using Access' import data routine.