[Solved] On Error GoTo - Could not make it work

Discuss the spreadsheet application

[Solved] On Error GoTo - Could not make it work

Postby gurkand » Fri Oct 19, 2018 7:02 pm

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.
Last edited by gurkand on Fri Oct 19, 2018 10:57 pm, edited 1 time in total.
Apache OpenOffice 4.1.3
gurkand
 
Posts: 8
Joined: Wed Feb 28, 2018 10:27 am

Re: On Error GoTo - Could not make it work

Postby Zizi64 » Fri Oct 19, 2018 10:50 pm

Please upload the full codelist of your macro, and a relevant ODF type sample file here.
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.1 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.1.2 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7358
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: On Error GoTo - Could not make it work

Postby gurkand » Fri Oct 19, 2018 10:55 pm

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.
Apache OpenOffice 4.1.3
gurkand
 
Posts: 8
Joined: Wed Feb 28, 2018 10:27 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 24 guests