Skip blanks is not designed for that purpose.

See help on "skip blanks" for an explanation of what that command means.

Basically it won't delete data in the destination range if source range
contains blank cells.

To remove blanks rows, select a column and F5SpecialBlanksOK

EditDeleteEntire Rows.


Gord Dibben MS Excel MVP


On Fri, 26 Sep 2008 13:38:06 -0700, toomuchwrinkles
wrote:

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?