Forum Discussion
Runtime error 6 overflow with Dim Double. MacOS Catalina - Excel 2019 - VBA 7.1
- Andrew_Duncan54Sep 05, 2023Copper Contributor
Same problem is occurring with MacOS 13.5.1, MS Excel for Mac 16.78, Office 365.
Sub test2() Dim a As Long Dim b As Long a = 0 b = 10 Debug.Print a; b a = b 'a = Round(b, 10) Debug.Print a; b End Sub
This generates a Run-time error '6'. If the type is changed to any other numeric type the problem does not occur. If the to be assigned variable is processed by a function such as Round (see comment line in code) the error does not occur.
- sibes5Nov 09, 2023Copper Contributor
PeterGallin, Haytham Amairah , I have the same (run-time error '6' overflow) when I open WORD....
.
... it seems to happen only when Excel is opened (but not necessarly running). I red the answers and flow the links but didn't find answers to my situation.
I'm using a MacBookpro 2019 with Sonoma 14.1.
Can someone could explain to me what's happening and what to do... in a way understandable for a not-so-knowing-informatic-technicallity person (specifically I'm not used with coding and using the terminal... But I can learn)?
Thank you, best regards
- Andrew_Duncan54Nov 10, 2023Copper ContributorWith Excel 365 Mac, I subscribe to the Insider program/Beta Channel. I found the problem went away with the next incremental upgrade. So, it appeared to be a temporary MS Excel problem.