Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I started getting this error a little while back.
Run-time error '1004': Cannot run Visual Basic macro because of a syntax error. This macro is activated by a button on my worksheet. The first time I press it, I get the error. However, the first error does not allow me to click "Debug". I press the button again and the error comes up again. This time I can click "Debug" which highlights "Application.Calculate". I can continue running the macro code by pressing the triangle or play button...or I can close the VB editor and click the button that calls the macro. In either case, the macro runs through without error. Any ideas why this error occurs at "Application.Calculate"? Thanks, Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run-time error "1004" Select method of range class failed | Excel Discussion (Misc queries) | |||
Run time error 1004: "No list was found.." | Excel Programming | |||
1004 "Application-defined or object-defined error" | Excel Programming | |||
"Run Time Error 1004 Application Defined or Object Defined Error." | Excel Programming | |||
"Run-time error '1004'" Method 'Range' of object '_global' failed. | Excel Programming |