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.

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.