Runtime Error 1004

karraj · Mar 13th, 2002, 01:37 PM

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 · Mar 13th, 2002, 02:56 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 01:37 PM	#1
karraj Board Regular Join Date: Mar 2002 Posts: 76	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.

Mar 13th, 2002, 02:56 PM	#2
karraj Board Regular Join Date: Mar 2002 Posts: 76	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