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.
"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.