Select column C and delete blank entire rows Till C300

**HaroonSid** · 05-04-2014, 05:55 AM

hello
i want to delete entire blank row from column C2:C300
i mean if i have data c2:c100 then c101:c300 delete entire blank rows

thanx

**cbatrody** · 05-04-2014, 06:12 AM

Hi,

Select the rows to be deleted, press "Ctrl" & "-".

**HaHoBe** · 05-04-2014, 06:46 AM

Hi, haroon2015,

if there are values in the cells:

Sub EF1008501()
Range("C2:C300").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub

Ciao,
Holger

**HaroonSid** · 05-04-2014, 07:17 AM

Hello HoHoBe

i was too close

btw perfect thanx

+1 repu will add u

**Faridwahidi** · 05-04-2014, 08:55 AM

Hi,

easy way to do it without macro,

1. select data C2:C300
2. Press F5
3. Special
4. Blanks
5. press "Ctrl" & "-"
6. entire row.

Re: Select column C and delete blank entire rows Till C300