Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a macro procedure in a excel spreadsheet.
----------------------------------------- Private Sub PrintAndCalculatePercentChanges(rownum) On Error Resume Next Cells(rownum, 9) = (Cells(rownum, 2) - Cells(rownum, 6)) / Cells(rownum, 6) 'If any error messages have occured then clear them If Err < 0 Then Err.Clear End If End Sub ----------------------------------------- When this is executed on my computer, all errors in the procedure are ignored. As they should be. However, when I run this procedure on another computer. The macro halts on a divide zero error in this procedure!!! Which means that for some reason the 'On error resume next' statement is being ignored. Is there any reason why this would be occuring? A missing referance or something? -J |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Autofill & On Error Resume Next | Excel Discussion (Misc queries) | |||
On Error Resume Next (when next statement is Do Loop ...) | Excel Discussion (Misc queries) | |||
ON ERROR RESUME NEXT | Excel Programming | |||
On Error Resume Next | Excel Programming | |||
On Error Resume Next | Excel Programming |