Error when running the macro in excel

[andrei]

Hi I am a new owner of a muse headband

I recorded all the activity in .csv file and followed the instructions from: https://musemonitor.com/Macro.php
I have a MacBook Air and excel 2011 for mac
When I run the macro I get this error: Run time error 1004 Method 'Range' of object '_Global' failed


When I click debug it shows me this line highlighted with yellow
Range("AM1:AR" & numRows).Select


Please help.

Thank you,
Andrei

[James]

On line 16 in the Macro, you'll see:

Code: Select all

    OldExcel = False 'Enable for older versions of Excel (e.g. 2003, Excel for Mac)

Set this to True, as you're using the old Mac version of Excel, and let me know if that fixes it.

Alternatively, you can use the online viewer here: https://musemonitor.com/Chart.php

[andrei]

Thank you James. I set it to True but I still get the same error.
I used the online version but I saw that the excel version has more graphs ... ((

Shall I check something else?

Thank you anyway,
Andrei

[James]

There's only one graph with the excel version. The online version has way more, just check the little boxes to change type.

Email me your file and I'll take a look at it.

[pete0121]

I have an error as well. Running excel in Mac version. Does it run in mac version.

ActiveSheet.Shapes.AddChart2(227, xlLine).Select

is where it gets stuck

[James]

Did you change OldExcel to true, as per the above instructions for old versions of Excel?