copy the values  onto a new worksheet, (in say a1, to a6), then save
the new worksheet as a .csv (see the vba  editor help file  for saveas..
. to get teh correct syntax).

Prob loads of other ways of doing it, but that was the first way to
spring to my mind.