Export Selection as .csv replace empty cells with "None"

Good day everyone,

I am working with the following macro:

Please Login or Register  to view this content.

It asks, what range I would like to export as .csv, what I want to save it as and then exports as .csv. However I need my empty cells to be filled with a "none" value.

How would I do it so this "none" value appears only on the output file and does not effect my base worksheet?

Thank you very much.

For any future people who search for this topic the code that works is as follows below:

Please Login or Register  to view this content.