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.

Web design by Will Woodgate