Hi there
When the server generates csv files for the data I requested, I think it inserts "invisible" values in between each section, and that causes
Columns("a:a").SpecialCells(xlCellTypeConstants, 3).areas.count = 1
I suspect it could be cr/lf or how unix does cr/lf vs dos.
Any ideas how I can make those blank rows really "blank" ?
Bookmarks