VBA

Visitor

Hi everyone,

I keep on having an error when i run this very simple code:

dim x as double

x=20.2

When i run the code (play button), it runs ok, no problem.

When i debug (line by line), i get a runtime error 6, overflow (attached image).

I tried different types of variables with decimal places (single, currency, ect.) but the story does not change.

The tecnical support told me to remove a plist file (com.microsoft.excel.plist), but it didn't work.

I use a mac(catalina 10.15.7) and excel 16.47

How can i sort this problem?

Thanks in advance for anyone who is going to help me

0 Replies