Excel question VB question

[Epidemic]

Dim StrtRWf2 As Long
Dim RPCF2 as Integer

Sub Macro3()
RPCF2= 375
Cl = 89

StrtRWf2 = (CL - 1) * RPCF2 + 3 ' Start Row for F2 data

End Sub

Ok I run this macro and it gives me an overflow error. Originally I DIM'd the variable as Integer but I have exceeded the 16 bit 32,000 number.

So I tossed in a DIM as Long and that should allow for +2 billion to - 2 billion.


Any ideas why it is still overflowing.

I know I have solved this in the past but cant for the life of me remember the sollution.

[Zitch]

That subroutine should assign 33003 (result of the calculation) into StrtRWf2, which a long type should handle. I'm not seeing where the issue might lie (unless you have a StrtRWf2 dimmed as an integer elsewhere and it's using that for some reason...)

Hey! You added to it since then!

Try setting up RPCF2 as a long. It's possible that the system is expecting an integer output between Cl and RPCF2, and that's overflowing...

[Zitch]

Just tested it myself, and yes, it's expecting an integer from (CL - 1) * RPCF2 + 3 because everything in there is an integer. If you dim RPCF2 as long, it'll work.

[Epidemic]

Excellent.

I just solved it myself but through a much less scientific method.

I just started Dimming all the components to long out of frustration.

I am still not quite sure why it fails though.

Scenario 1

pickle = 32,000 *10 ------------ works just fine

Dim Pickle as integer

Pickle = 32,000* 10 -------------- works fine

but

RPCF2= 375
Cl = 89

StrtRWf2 = (CL - 1) * RPCF2 + 3


Well I guess I am just a butcher when I program.