Forum Discussion
Runtime error 6 overflow with Dim Double. MacOS Catalina - Excel 2019 - VBA 7.1
14 Replies
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.
