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