units = ActiveCell.Value overflow

[cbh35711]

The subject pretty much sums it up.
I've got a number in a cell that i want to divide by 3, but for some reason i keep getting an overflow error when i try to save a number from a cell into a variable. The variable is an int, and the number shouldn't be too big to fit.

Thanks for the help,

Chris

[Excelenator]

Try changing the variable type to Double. Int is not going to accept your value if it has decimals.

[Tom Ogilvy]

What's the number. What happens if you change the type to Long.

--
Regards,
Tom Ogilvy

"cbh35711" <[email protected]> wrote in
message news:[email protected]...
>
> The subject pretty much sums it up.
> I've got a number in a cell that i want to divide by 3, but for some
> reason i keep getting an overflow error when i try to save a number
> from a cell into a variable. The variable is an int, and the number
> shouldn't be too big to fit.
>
> Thanks for the help,
>
> Chris
>
>
> --
> cbh35711
> ------------------------------------------------------------------------
> cbh35711's Profile:
> http://www.excelforum.com/member.php...o&userid=30276
> View this thread: http://www.excelforum.com/showthread...hreadid=566328
>

[Tom Ogilvy]

> Int is not going to accept
> your value if it has decimals.


I couldn't reproduce that:

b% = 8/7
? b%
1
? typename(b)
Integer


It certainly won't hold the decimal portion, but that won't cause an
overflow error.

--
Regardes,
Tom Ogilvy



"Excelenator" <[email protected]>
wrote in message
news:[email protected]...
>
> Try changing the variable type to Double. Int is not going to accept
> your value if it has decimals.
>
>
> --
> Excelenator
>
>
> ------------------------------------------------------------------------
> Excelenator's Profile:
> http://www.excelforum.com/member.php...o&userid=36768
> View this thread: http://www.excelforum.com/showthread...hreadid=566328
>

[keepITcool]

You can easily overload a long...

Sub OverKill()
Dim d#, l&
d = 1E+100
l = d
End Sub


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Tom Ogilvy wrote in <news:<u8#[email protected]>

> What's the number. What happens if you change the type to Long.

[cbh35711]

perfect, worked great.

Thanks

Chris

[Tom Ogilvy]

Really. So they weren't kidding in the help when they said:

Long (long integer) variables are stored as signed 32-bit (4-byte) numbers
ranging in value from -2,147,483,648 to 2,147,483,647

--
Regards,
Tom Ogilvy

"keepITcool" <[email protected]> wrote in message
news:[email protected]...
>
> You can easily overload a long...
>
> Sub OverKill()
> Dim d#, l&
> d = 1E+100
> l = d
> End Sub
>
>
> --
> keepITcool
> | www.XLsupport.com | keepITcool chello nl | amsterdam
>
>
> Tom Ogilvy wrote in <news:<u8#[email protected]>
>
>> What's the number. What happens if you change the type to Long.

[Tom Ogilvy]

You can easily overload a double...

Sub OverflowDouble()
Dim d#
d = CDbl(1E+308) * 2#
End Sub

is that helpful?



--
Regards,
Tom Ogilvy

"keepITcool" <[email protected]> wrote in message
news:[email protected]...
>
> You can easily overload a long...
>
> Sub OverKill()
> Dim d#, l&
> d = 1E+100
> l = d
> End Sub
>
>
> --
> keepITcool
> | www.XLsupport.com | keepITcool chello nl | amsterdam
>
>
> Tom Ogilvy wrote in <news:<u8#[email protected]>
>
>> What's the number. What happens if you change the type to Long.

[keepITcool]

Tom, okay i was blunt

my point was..
a cell may hold a large floating point value.
even when assigned to a long variable it can overload.
(infamous example: ?cells.count in excel 2007)

Tip for OP:
an integer holds -32768 to +32768 only.
a long holds from -2 to +2 billion.

IN VBA just dont just Integer but Long for al your counters.
the extra bytes dont matter as much as they did in 1980.

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Tom Ogilvy wrote in <news:<[email protected]>

> You can easily overload a double...
>
> Sub OverflowDouble()
> Dim d#
> d = CDbl(1E+308) * 2#
> End Sub
>
> is that helpful?