Ask Your Question
0

Where do I find explanations for error messages?

asked 2021-01-10 22:51:33 +0200

MikeMcClain46 gravatar image

updated 2021-01-22 22:59:41 +0200

I've got cells in a spreadsheet showing 'Err:507' 
Where do I find the descriptions for these error codes?

Also I'm also seeing: "Basic runtime error. '6' Overflow."
How to find what's causing this error?

Thanks,
Mike
edit retag flag offensive close merge delete

Comments

For the cause of the Basic error, you have to debug the macro. I guess, you can find a lot of tips on debugging programs on the Internet.

gabix gravatar imagegabix ( 2021-01-11 07:15:44 +0200 )edit

This module has 92 macros in it. It's a stock tracking spreadsheet from Excel. Before trying to convert to LibreOffice Calc, I would download today's closing quotes into quotes.csv then in Excel all I had to do was enter 'Control-q' and the quotes would be imported and calculations run.

When I run a macro I get the " BASIC runtime error. '6' Overflow." message in a popup window. Scrolling through the module's listing there is nothing highlighted to indicate where the problem might lie.. Click OK and the macro runs without error. How do I find where the overflow is? Whether the macro I call inserts a new column or simply selects a range of cells the error window pops up, the cursor in the IDE jumps to the bottom of the module and the macro does what I expect what I expect with no problems. I ...(plus)

MikeMcClain46 gravatar imageMikeMcClain46 ( 2021-01-13 02:26:38 +0200 )edit

It came to me in the middle of the night that this is what was causing the overflow. Public Const blue As Integer = &h3465a4 It should have been declared as a Long. Why the IDE didn't show where the problem was is beyond me. None the less, this problem solved.

MikeMcClain46 gravatar imageMikeMcClain46 ( 2021-01-15 16:43:35 +0200 )edit

@MikeMcClain46: on this site, solved questions are flagged by clicking on the gray check mark (only once!) of the correct answer so that this flag is forwarded on the home page.

But according to your previous comment, you should answer your own question explaining the incompatibility between your declaration and the data you put into the variable.

ajlittoz gravatar imageajlittoz ( 2021-01-16 08:46:44 +0200 )edit

2 Answers

Sort by » oldest newest most voted
1

answered 2021-01-10 23:06:25 +0200

Opaque gravatar image

updated 2021-01-10 23:10:34 +0200

edit flag offensive delete link more

Comments

Thanks, Opaque. That will help. Mike

MikeMcClain46 gravatar imageMikeMcClain46 ( 2021-01-13 02:27:46 +0200 )edit
0

answered 2021-01-17 17:14:07 +0200

MikeMcClain46 gravatar image

Opaque's answer, above, answered the first part of this.

The second was due to my declaration :

Public Const blue As Integer = &h3465a4

It should have been declared as a Long because the number is too big to fit in an Integer.

Thanks to ajlittoz for the pointer.

Be Well, Mike

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2021-01-10 22:51:33 +0200

Seen: 98 times

Last updated: Jan 22