J
J S
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
-----------------------------------------
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