Save Range or Worksheet as CSV file
There is a bug in Mac Excel that not allow you to save a range or worksheet to a csv file directly like you do in Excel for Windows, you will get a 1004 error Method 'SaveAs' of object'_Workbook' failed. The workaround is to save it as FileFormat xlsx first and then as CSV. If you have another solution let me know so I can update the info on this page.
Example below save the active sheet as CSV file on your Desktop
The example below save a range from Sheet1 as CSV on the Desktop.