Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Long data type overflow
Hi !
The following code generates Overflow error: Dim NumberP As Long NumberP = 1078282205 * 31 According to MSDN: Long variables are stored as signed 64-bit (8-byte) integers ranging in value from -9,223,372,036,854,775,808 through 9,223,372,036,854,775,807. What is going wrong there ? Maybe VBA Long data size differs from VB Long data size ? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo | Excel Discussion (Misc queries) | |||
when I type a long number it shows up as smaller number and + | Excel Discussion (Misc queries) | |||
how do I type long paragraph into a cell? | Excel Discussion (Misc queries) | |||
Data overflow to second worksheet | Excel Worksheet Functions | |||
VBA overflow | Excel Programming |