Macro to copy highlighted cells to csv file

[Martin]

I need a macro to copy all cells that are selected then paste them onto a
csv file. I'm able to get the cell range using Selection.Address but how do
I copy them onto a csv file?

Thanks.

 

[Jim Rech]

The simplest way would probably be to copy the selection to a new workbook
and then save the active sheet as a CSV.

--
Jim
|I need a macro to copy all cells that are selected then paste them onto a
| csv file. I'm able to get the cell range using Selection.Address but how
do
| I copy them onto a csv file?
|
| Thanks.
|
|