Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Runtime Error 1004

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.




  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •