run-time error '9': Subscript out of range
 

I received an error message (run-time error '9': Subscript out of range) when
I tried to run the macro in Excel.

I have a macro set up in Excel to export the data from Excel to Access. I
have been using it for years, and I am starting to receive that error message
yesterday.

Please help. Thanks.

run-time error '9': Subscript out of range
 

Would need to know the code and what line of code fails with this error.
--
- K Dales


"AccessHelp" wrote:

I received an error message (run-time error '9': Subscript out of range) when
I tried to run the macro in Excel.

I have a macro set up in Excel to export the data from Excel to Access. I
have been using it for years, and I am starting to receive that error message
yesterday.

Please help. Thanks.