Your question is not easy to reply.

Do you want to know the vba code for this to happen on a Button or
Macro, or do you want to (manually) Sort the rows and bulk-delete all
----- lines, then re-sort into original sequence?
(ie, insert a column and sequence number = row - copy that column and
Paste Special = Values back over itsself, insert a further column and
test for XXXXX and YYYYY and note all others as 'del', sort over this
second column, delete all 'del' lines, re-sort over the first inserted
column and delete the two worker columns)

Are the ----- lines truly ----- or are they other (undefined) data.
What is the true definition of XXXXX lines and YYYYY lines?

Any further clues?


bhola-bhala Wrote:
I am trying to remove all extra rows between some text.. lets say:

XXXXX
-------
-------
YYYYY


I am trying to remove all ------ part like i want to keep row #1 & #3
but i want to remove row #2, ,how can i do that? And i am not talking
about 1 row, there are more than 10,000 records :)


--
Door
------------------------------------------------------------------------
Door's Profile: http://www.excelforum.com/member.php...o&userid=33068
View this thread: http://www.excelforum.com/showthread...hreadid=528804