| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 and VB declaring number as double
I have a program in VB in excel that parses a text file and loads the numbers
into the spread sheet. The problems is the numbers have gotten bigger, and are now over 2.2 billion. Dim Qty as long I had the declaration above and then changed it to Dim Qty as double but it did not change the dim it still crashes if number is 2.17 billion or higher gary |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: How to find 0.00 in a column of number? | Excel Discussion (Misc queries) | |||
| Excel 2002: How to convert number to text ? | Excel Discussion (Misc queries) | |||
| Excel 2002 : How to deduct the first and last number ? | Excel Discussion (Misc queries) | |||
| Declaring variables | Excel Discussion (Misc queries) | |||
| Declaring variables | Excel Discussion (Misc queries) | |||
Threaded Mode
