View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J S J S is offline
external usenet poster
 
Posts: 11
Default On error resume next statement ignored!

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