Hey, quick and easy, i have been over my data a lot. I have an excel file in whcih i have a macro update the data into a new excel file. In my database i have saved import steps attached to buttons depeneding on the table. Now i have had no issues until this one table. i have double check my column headings for saved words etc in access, formatting, etc. There all values in my excel worksheet not formulas. It keeps saying subscript out of range. I have 157 column headings and they all match the field headings.
any ideas, ive run out haha.