You have another response at your original thread.

lucidr wrote:

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?

--
lucidr
------------------------------------------------------------------------
lucidr's Profile: http://www.excelforum.com/member.php...o&userid=36699
View this thread: http://www.excelforum.com/showthread...hreadid=564635

--

Dave Peterson