I have two listboxes. The 1st listbox has the numbers 1 to 10 in it. The 2nd listbox has the numbers 1.00 to 10.00 (increasing by 0.01) in it. And when I calculate these numbers everything is fine. But as soon as I increase the 1st listboxes' numbers to 100,000 (1 to 100,000) and I do a calculation using the number 100,000 I get a run time error 13.

Questions...

I shouldn't be able to do a calculation even when the numbers are low (1 to 10) because these numbers are strings and therefore you can't calculate strings, but it does, so the first question is... How is this possible?

My second question is, how can I calculate the 100,000 number without creating a run time error 13?

Many thanks.