Apache OpenOffice Community Forum

Hello All,
Trying to ignore records with values causing calculation errors. All I ned is to simply continue with the next record. Have the following:

...
Do While 1=1
On Error GoTo xxthere
...
<code>
...
xxthere:
Loop
...

I tried putting the On Error statement to before Do, did not help.

The error I receive is: Inadmissable value or data type. Index out of defined range.

What am I doing wrong?

Thanks in advance for the help.

Please upload the full codelist of your macro, and a relevant ODF type sample file here.

Zizi64 wrote:Please upload the full codelist of your macro, and a relevant ODF type sample file here.

Thanks.
I have fixed the problem now, it was caused by the 1's in the RND. I was not aware that RND can produce 1...
No need to follow this On Error issue now.