Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Calculate - Runtime Error
Does anyone know why the following line might cause a Runtime Error?
Application.Calculate I understand that the surrounding code may be suspected to be involved, but running the same Macro twice will not necessarilly have a problem. Additionally, this has occurred in other Sub routines on the same code. The runtime error pops up, I go to Debug and that line is highlighted. If I hit F8, it runs that line with no problem....or if I hit F5, it continues running. Any ideas? Thanks, Paul -- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Calculate - Runtime Error
Doesn't anyone know of a circumstance in which the line
"Application.Calculate" might cause a Runtime Error? The exact error is: ____________________________________________ Run-time error '1004': Cannot run Visual Basic macro because of a syntax error. ____________________________________________ I am able to 'Debug' and the Calculate line is what is highlighted. I can continue step by step (F8) or I can continue fully (F5). In one case I have a looping sequence and it errors every time on this line. But it will always continue if I tell it to using F5 or F8. In this particular looping sequence, it happens over and over for as many times as it loops. It's frustrating. It also happens on different computers using the same file(s). Excel 2002. Thanks for any ideas. Paul -- "PCLIVE" wrote in message ... Does anyone know why the following line might cause a Runtime Error? Application.Calculate I understand that the surrounding code may be suspected to be involved, but running the same Macro twice will not necessarilly have a problem. Additionally, this has occurred in other Sub routines on the same code. The runtime error pops up, I go to Debug and that line is highlighted. If I hit F8, it runs that line with no problem....or if I hit F5, it continues running. Any ideas? Thanks, Paul -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
runtime error '1004' application or object defined error | Excel Programming | |||
Runtime error 1004 on an application.count statement | Excel Programming | |||
runtime error '1004' application or object defined error. Please help | Excel Programming | |||
runtime Error '424' using Application.Selection | Excel Programming | |||
runtime error 75 when I run the application for second time | Excel Programming |