deleting blank lines

[sandeepmur]

Hi,

How can I delete the blank lines in my excell sheet ? the blank lines appear inbetween the data..

Is there somehow I can delete all the blank lines at once ?

thnx

 

[lupins46]

Sort the rows?

 

[earthandfire]

Alternatively have a look at this thread: thread68-1087290, it contains code for deleting blank rows.

Hope this helps.

 

[sandeepmur]

I tried the sort option (though not sure if it would remove the blank lines) but I get an error message:

"This operation requires the merged cells to be identically sized "

any suggestions?
thnx

 

[sandeepmur]

think i got it .. had to select just the columns needed..
thnx