delete gap lines

[majidsiddique]

Dear,

i have problem in excel. how i can remove quickly line delete in S.No column (B). there is a gap between lines, excel can identify automatic gap line and delete them immediately. data is too lengthy. only S.No column(B) is main criteria in a sheet.

Item	S.No	Description	Lot	Qty
12010	1	teri towel	12111110	2
	2	teri towel	12111110	2
	3	teri towel	12111110	2
	4	teri towel	12111110	2
	5	teri towel	12111110	2
	6	teri towel	12111110	5
	7	teri towel	12111110	5
	8	teri towel	12111110	5
30010	1	wingles	2001889	6
	2	wingles	2001889	6
	3	wingles	2001889	6
	4	wingles	2001889	6
	5	wingles	2001889	7
	6	wingles	2001889	7
	7	wingles	2001889	7
	8	wingles	8899888	9
	9	wingles	8899888	9
40010	1	driver22	55551	12
	2	driver22	55551	12
	3	driver22	66662	12
	5	driver22	66662	12

<colgroup><col span="2"><col><col span="2"></colgroup><tbody>
</tbody>

 

[Rick Rothstein]

If the "gap" in Column B is a truly blank cell (absolutely nothing in it), then this macro should work fairly quickly...

Sub DeleteGapRows()
  Columns("B").SpecialCells(xlBlanks).EntireRow.Delete
End Sub

 

[majidsiddique]

Thanks Rick,

it works properly. thanks a lot.

Majid

 

[majidsiddique]

Dear Rick,

is it possible to remove any cell value selected gap lines first then apply to delete line? like selected gap lines volume D cell value " hhhh " and E " yuuu"

kindly tell me.

Thanks