Runtime Error 1004

[karraj]

I get this error, once a while running my VBA code.
"Run Time error 1004 Method'displaystatusbar ' of object '_Application' failed.

If try to comment this line out, I get the error occurs in the next line...

"Run Time error 1004 Method 'Calculation' of object '_Application' failed.

The subroutine this error occurs is the one I am using to create a new workbook.

If i close my workbook and then open again, I do not see this error.

Any help would be great.

 

[karraj]

Found the solution, for someone faced with this error in future....

A Bug with EXcel 97 , just select a worksheet and a range on it , before calling the calculation method.

K