Sub TestFunction() Dim var As Double var = 25 * 24 * 23 * 22 * 21 * 20 End Sub
I am receiving an overflow error for this vba operation. when i run it in a cell with functions i get 127,512,000
what could possibly be an error for this? this should be well below the size limit for this data type right?