VBA overflow error

[Schiavoni]

Hello,

Ik have this vba-code:

Please Login or Register  to view this content.

The value in Range("AG1") changes every time, because it's a sumformula who calculates differences in values between cells.

The vba-code is working well, but when i put some more formulas in different cells, then I got some error:

Please Login or Register  to view this content.

The error goes to:

Please Login or Register  to view this content.

When I delete some formulas in the worksheet, the code is running well.

What do I need to change in the vba-code, to prevent the overflow error?

[6StringJazzer]

What is the value of arrBytes(i, j) when this error occurs?

[Schiavoni]

What is the value of arrBytes(i, j) when this error occurs?

In the range are a lot of Hex decimals that changes when the values in others worksheet changes too.

There are some worksheets with values and the vba-code has to calculate Range("AG1") everytime. When Range("AG1") has some value, the loop has to stop and run the vba-code to create the file with the Hex-decimals.

[MrShorty]

When it errors, what value is in AG1? Any chance it represents a number larger than 255? According to the documentation (https://docs.microsoft.com/en-us/off...byte-data-type ), the Byte data type stores numbers from 0 to 255, and returns the overflow error if the number is outside of that range.

[Schiavoni]

The value is under 200. I already have deleted some formulas in a worksheet and now the vba-code is working. The formulas I add to the worksheet, don't affect the value in AG1. When I add them, I got the overflow error. The vba-code created some files before the overflow error appears and stops running the code.

[6StringJazzer]

Aside from your error, this syntax is a little strange (but legal) and I am guessing it does not do what you think it does. Can you describe what you want to check for here?

Please Login or Register  to view this content.

[Schiavoni]

Aside from your error, this syntax is a little strange (but legal) and I am guessing it does not do what you think it does. Can you describe what you want to check for here?

Please Login or Register  to view this content.

When the value of AG1 is equal and between 40 and 80, the vba-code has to go further, otherwise the worksheet has to calculate again and loop.
In some cells I have a formula:

Please Login or Register  to view this content.

When 10 cells changes values, the total of the changes is in AG1. When this value is between 40 and 80, the vba-code has to run after the loop, otherwise calculate again.

[6StringJazzer]

In that case the expression is incorrect. The expression you are using always evaluates to TRUE and will always exit the loop after the first time. You want this.

Loop Until Range("AG1").Value >= 40 And Range("AG1").Value <= 80

[Schiavoni]

In that case the expression is incorrect. The expression you are using always evaluates to TRUE and will always exit the loop after the first time. You want this.

Loop Until Range("AG1").Value >= 40 And Range("AG1").Value <= 80

Thanks for the answer, but it isn't working. I've added some extra formulas in the worksheet and changes the Loop-code, but I get the overflow error again. When I don't add the extra formulas, I don't get an error.

[6StringJazzer]

Thanks for the answer, but it isn't working. I've added some extra formulas in the worksheet and changes the Loop-code, but I get the overflow error again. When I don't add the extra formulas, I don't get an error.

The change to the Loop code is completely unrelated to the overflow error. It's a logic error that I noticed.

If adding and removing formulas causes and resolves an overflow error, then there is a problem that we can't solve just by looking at code. If you attach your file and identify which formulas you removed we can diagnose the overflow problem.

[Schiavoni]

I've found what was wrong with the formulas. Some values turned below zero and can't be converted to Hex-decimals. So, I've changed that and now the code is working well.