Overflow error when declaring variables
Hi,
When I declare the variable I get an overflow error -
depending on how it is declared.
Public IFundTable()
then in
Sub Macro1()
Redim IFundTable(1 to 5, 1 to 158510) 'There is no overflow error
Redim IFundTable(1 to 5, 1 to Count*10) 'Count = 15851, there is an error
Why?
Thanks for your help
|