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?
T,123456789,,A COMPANY LTD,X,D,250706,0506,CSV01
84289000,,DDP,,,,IT,,
84289000,,DDP,,,,FR,,
84289000,2094.44,DDP,10,17,,DE,,
84289000,2574.97,DDP,10,53,,FR,,
84289000,2394.83,DDP,,,,IT,,
84289000,2805.87,DDP,10,6,,IT,,
84289000,1008.1,DDP,,,,NL,,
84289000,945.27,DDP,,,,NL,,
84289000,92.65,DDP,10,0.5,,ES,,
84289000,636.99,DDP,10,10,,IT,,
84289000,7833.33,DDP,,,,DE,,
84289000,67.12,DDP,10,0.5,,FR,,
84289000,1318.33,DDP,10,1.5,,FR,,
84289000,431.61,DDP,10,2,,SE,,
84289000,112.64,DDP,10,0.3,,FR,,
84289000,67.12,DDP,,,,FR
84289000,1969.53,DDP,,,,IT
84289000,479.93,DDP,10,14,,DE
84289000,3587.6,DDP,10,92,,ES
84289000,93.33,DDP,,,,SE
84289000,971.83,DDP,,,,BE
84289000,3181.43,DDP,10,12.5,,FR
84289000,161.5,DDP,10,0.5,,SE
84289000,171.91,DDP,10,0.3,,FR
84289000,2200,DDP,,,,
84289000,1347.35,DDP,,,,IT
84289000,480,DDP,,,,DE
84289000,617.57,DDP,10,0.5,,FR
84289000,545.65,DDP,10,10,,NL
84289000,484,DDP,10,3.5,,IT
84289000,466.26,DDP,10,18,,IT
84289000,523.83,DDP,10,18,,IT
Bookmarks