We had a problem like this a while back where a sheet we had been importing for years gave this or a similar error. As I recall we resolved it copying the cells were were using to a new worksheet and overwriting the original. Apparently there was something in the worksheet's empty cells that had been causing the problem.