Capabilities of a Long in VBA

Asked Mar 09 '18 at 15:55

Active Mar 09 '18 at 16:08

Viewed 43 times

I hope I haven't completely lost it. The following code gives me an Overflow Error:

Public Sub test()
    Dim lng As Long
    lng = 2147486647#
End Sub

Every time I type 2147486647 it adds the # which makes it double. If I try and use the ? to make it a long (2147486647?) I get a compile error:

Expected: end of statement

Also trying to cast it as a long explicitly gives an overflow error as well. Am I losing it? Is the max value for a long smaller than this?

I am working in Zenon by Copa Data. It is SCADA Software and might have something weird but I also tried this in excel with the same results.

edited Mar 09 '18 at 15:56

braX

11,506
5
20
33

asked Mar 09 '18 at 15:55

Evan

3

The maximum value for a `Long` in VBA is 2,147,483,647. Your number is too large. – braX Mar 09 '18 at 15:58
@braX yup that did it. Must've just fat fingered it. Thanks – Evan Mar 09 '18 at 16:07

Capabilities of a Long in VBA

0 Answers0