Identifying macro starting point & combining macros

I am using the following code to identify any blank rows in a sheet and delete them:

Please Login or Register  to view this content.

Simple and works perfectly.

Then I use the following code to look at Column A and if it finds any cells that look blank, then delete that row.

Please Login or Register  to view this content.

Then I adjust the code to look into "E:E".

The problems I am having are as follows:

1. How do I code it so that it only starts deleting after a certain row, in this case ROW2

2. Can I combine these codes to make one macro to do all the steps I need?

Ive attached a spreadsheet showing a before and after example.

Hi dagindi,

I may be over simplifying things here, but it seems that you only want rows left (not deleted) where "Sales" is not in the applicable row in column C. That said, see how this goes - make sure you run the macro on a copy of the relevant tab first:

Please Login or Register  to view this content.

HTH

Robert

Hi dagindi
To do this

Please Login or Register  to view this content.

I believe you need to change this line of code from

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

Try this and see if it works for you.