Page 1 of 1
Error when running the macro in excel
Posted: Sun Sep 09, 2018 9:43 am
by 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
Re: Error when running the macro in excel
Posted: Sun Sep 09, 2018 3:59 pm
by 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
Re: Error when running the macro in excel
Posted: Mon Sep 10, 2018 7:46 am
by 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
Re: Error when running the macro in excel
Posted: Mon Sep 10, 2018 8:55 am
by 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.
Re: Error when running the macro in excel
Posted: Tue Mar 05, 2019 3:42 am
by 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
Re: Error when running the macro in excel
Posted: Tue Mar 05, 2019 8:58 am
by James
Did you change OldExcel to true, as per the above instructions for old versions of Excel?