PeterGallinI have found a temporary solution of the mentioned problem:Sub Test()Dim a As Varianta = 20.3End Sub

Haytham AmairahThank you again for your test. I am shure now that there is a problem with Excel on Mac and even the newest version on an brandnew MacBook 12". I had a chat with a Microsoft Expert yesterday and he promised me to contact the developpers so that there will be the solution in the next update. I hope ...

isabelaj 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 documentation article to learn more about it and how to fix it. Regards

Haytham Amairah 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.

PeterGallin A similar problem is discussed here in this link.

Runtime error 6 overflow with Dim Double. MacOS Catalina - Excel 2019 - VBA 7.1

14 Replies

Haytham Amairah
Bronze Contributor
Aug 03, 2019
isabelaj

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 documentation article to learn more about it and how to fix it.

Regards
- PeterGallin
  Copper Contributor
  Aug 30, 2019
  Haytham Amairah
  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.
  - Haytham Amairah
    Bronze Contributor
    Aug 31, 2019
    PeterGallin
    
    A similar problem is discussed here in this link.

Forum Discussion

Runtime error 6 overflow with Dim Double. MacOS Catalina - Excel 2019 - VBA 7.1

14 Replies

Resources