Thread: Extra trailing commas in exported CSV
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lucidr[_3_] lucidr[_3_] is offline
external usenet poster
  
Posts: 1
Default Extra trailing commas in exported CSV

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

Reply With QuoteReply With Quote