If you have done lots of editing, running of macros, etc. on the active
worksheet, then its UsedRange property will still include a lot of "empty"
cells that will be eliminated after the workbook is saved.

Try copying only the cells that still have data that you want to export to
the CSV file to a new worksheet in a new workbook, then saving.

--
Regards,
Bill Renaud