Created by Jerry Carter on 07/27/2011. Modified: 07/27/2011 08:05 AM


Overflow (non-specific)


I found that you can easily get an overflow error when trying to step over item.values if item.text = "@ERROR". Adding a check for this works around the issue.


If Not item.text="@ERROR" Then
'do something with item.values
End If



Item is type Number List and contains simply @ERROR, no quotes. A formula that errors on the form can deposit this value in the field.

Jerry Carter on 07/27/2011 08:06 AM

Use this form to add a suggested cause or solution which you think might help.

Adding content is disabled. The spammer have won.