Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a macro that save a particular worksheet as a .csv file. When I open
the resulting file in Notepad, I can see that there are lines of blank information at the end. That is, there are only commas and nothing else. This will not work for my purposes. What can I add to my macro to remove those blank lines at the end of the data? If it is helpful, I can remove all blank lines, it doesn't have to be only at the end. They can be either removed on the original worksheet or on the .csv file. Thanks in advance for your help, Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Blank Lines Question | Excel Discussion (Misc queries) | |||
How do I ignore blank lines | Excel Discussion (Misc queries) | |||
Macro not recognizing blank lines as blank | Excel Discussion (Misc queries) | |||
Blank lines | Excel Programming | |||
how to automatically insert blank lines in between non-blank lines | Excel Programming |