Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

LO Basic Macro equivalent to MS Excel VBA line: "If Err.Number = 6 Then OutOfBounds = True"

Hi all,

I am trying to translate a MS Excel VBA Macro into one for LO Calc, and there is a line at the beginning of the Sub that reads:

On Error GoTo OverflowTest

Then at the end of the Sub, there is:

Exit Sub

OverflowTest:
    If Err.Number = 6 Then OutOfBounds = True
End Sub

Naturally, LO doesn't like this, so what would be the equivalent?

Thanks in Advance