Forum Discussion

isabelaj

Copper Contributor

Aug 02, 2019

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

Macros and VBA

PeterGallin

Copper Contributor

Apr 14, 2021

I am surprised that such a long time there is an answer on my problem. But now I would like to know how the problem is solved. Is there a new update for Microsoft Excel? (I do not want to change the operating system on my mac.)

Andrew_Duncan54

Copper Contributor

Sep 05, 2023

PeterGallin

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.

Andrew_Duncan54
Copper Contributor
Nov 10, 2023
With 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.
sibes5
Copper Contributor
Nov 09, 2023
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