i have written a macro that will save a nominated worksheet as a CSV

my problem is that when i have only one record in the worksheet
i.e.

Header 1, Header 2, Header 3
content 1, content 2, content 3

the CSV file size blows out to 1,281Kb

however when there is more than one record in the worksheet
i.e.
Header 1, Header 2, Header 3
content 1, content 2, content 3
content 1, content 2, content 3

the file size drops back to 1kb where is should be.

has anybody experienced this before?

how can i ensure the file size is kept to a minimum?