I turned the debugger on and it worked fine. I posted the error message and the exact line of code the problem occurs when the debugger is off. I data that is imported comes from two types of spreadsheets Lotus & Excel. The procedure with lotus does not work and when I made the change to Excel this month they are now working. We are in the process of moving everything over to Excel, but I am confused as to why it all works in 5.0, but in 6.0 the Lotus does not work.