Sometimes I export data from another progam in to Exel. The export always
inserts blank lines (rows) between the data. There are hundreds of rows of
data and it's very time consuming to manually delete these lines. I try to
copy the data and paste special to a new worksheet using the skip blanks
option, but it doesn't work. Any idea/feedback as to why?