Excel graphing macro - run-time error 1004

[ebor]

Hi,
when I excute the Excel Macro I get error 1004: Method 'Range' of object '_Global' failed
at this line
Range("AM1:AR" & numRows).Select

I am using Office 365 ProPlus Excel and Windows 10. CSV is saved under Android.

Using the "Online Graphing" with the same CSV it is OK.

Best regards

[James]

Please email me your CSV file and a screenshot of the Excel data created in the GraphingData tab after the fail.
Support@MuseMonitor.com

[James]

On some European versions of Excel, CSV files (which stands for Comma Separated Values), are set to use a semi colon instead of a comma.

You can change this back to a comma in your system regional settings.

Go to windows settings, choose "Click,Language And Region", then "Change date, time or number formats"

In the dialog that opens, click "Additional Settings" and change the "List separator" to a comma.

Alternatively, if you open the CSV file with notepad, you can add this text to a new row top of the file to let Excel know how to handle the separator:

Code: Select all

sep=,

ExcelCSVSep.png (25.4 KiB) Viewed 2795 times

Now when you load it, it will know to put each item in it's own column and the Macro will work.

[ebor]

Thank you! Great app, great support!

[Francois]

Hi James,
Same issue with error 1004 (I use a French Excel and a muse 2)
I followed your instructions, but both don't work.
May I send you my CSV file ?
Thanks
François

[James]

Sure. Also EMail me a screenshot of what you see in Excel when you open the file.
Is everything in the first column, or spread out properly?