Delete Entrie Row if entries in Column C are Blank

[NeedForExcel]

I have a data from Column A through E (Rows 1:500).

I want to delete the entire Row if a particular cell in column C is blank.

For E,g. if cell C5 is blank, I want the whole of Row 5 to get deleted.

I have already written a code, however it is not working.

Please Login or Register  to view this content.

Can any one tell what is wrong with it?

[wenqq3]

Please Login or Register  to view this content.

Hope it help

[benishiryo]

hi there~ here are a few things to consider:
1. does Column A determine where the last row is? if not, please change LastRow to:

Please Login or Register  to view this content.

2. to delete or insert rows, it's better to work backwards with the For Next Loop. for eg. if you have blanks in C2 & C3. then your original loop will delete row 2. after deleting, C3 becomes C2. but your loop will jump to check C3 now & miss out C2. so:

Please Login or Register  to view this content.

3. do not use:

Please Login or Register  to view this content.

the activecell could be anywhere. the loop does not select the cell. it just checks internally. so use:

Please Login or Register  to view this content.

4. you can't use:

Please Login or Register  to view this content.

either

Please Login or Register  to view this content.

or:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[NeedForExcel]

@benishiryo

Thank you for the inputs.. It really helped..

Regarding Point 1 - I have specified "A", as Column A determines my Last Row.

[NeedForExcel]

@wenqq3

Thank You for the code.. It worked perfectly..

[NeedForExcel]

@Benishiriyo

Hey!!

1 Thing I cud not understand is why did you use For Counter = LastRow To 2 Step -1

I saw your clarification which I was able to understand. However I could not understand how "For Counter = LastRow To 2 Step -1" achieves the same result as "For Counter = 2 To LastRow" this does.

Can you please clarify in brief so that I can understand the code I am using?

I'd be really grateful..