View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
S.E. S.E. is offline
external usenet poster
 
Posts: 15
Default blank lines at end

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