Extra trailing commas in exported CSV

[lucidr]

Hi All

I have some VBA that exports a sheet from my workbook as a CSV file. I
do some cleaning up on the sheet before it is exported:

wksCSV.Range("H2:AA65536").Clear
wksCSV.Range("A2:AA65536").ClearFormats

Despite this I consistently get two extra trailing commas on rows 2 to
16 (first row is a header, which is longer) in the resulting CSV (as if
H2:I16 contained something). Any suggestions?

 

[Kaak]

You will get as many comma's as columns
The number of columns is set by the header row

 

[lucidr]

This doesn't happen for rows beyond row 16. Does Excel do this in chunks
of 16 rows maybe? Another great bit of 'design'...

 

[Dave Peterson]

You have another response at your original thread.

 

[Dave Peterson]

Very good!

This doesn't happen for rows beyond row 16. Does Excel do this in chunks
of 16 rows maybe? Another great bit of 'design'...