Forum Discussion
Runtime error 6 overflow with Dim Double. MacOS Catalina - Excel 2019 - VBA 7.1
Hi,
Please provide some useful info about the problem!
The visible part of the code in the first screenshot doesn't seem to have an error!
However, the Overflow error is one of the most popular runtime errors in VBA, please check out this https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/overflow-error-6 to learn more about it and how to fix it.
Regards
I have exactly the same problem as isabelaj: When I declare a variable as double I cannot assign any value to that variable. It results always the overflow error message.
A similar problem is discussed here in this https://answers.microsoft.com/en-us/msoffice/forum/all/run-time-error-6-overflow-in-excel-vba/1f38291a-26ca-4b28-8c76-8b18b5cf0963.
Haytham AmairahThank you for your answer. But my problem is not the same because I receive the error message of overflow even with that little program:
Sub test()
Dim a As Double
a = 20.3
End Sub
Error message in the third line.
As I read in an other chat, this program runs well on a Windows Computer but not on the Mac.
PeterGallinI have found a temporary solution of the mentioned problem:
Sub Test()
Dim a As Variant
a = 20.3
End Sub