Code Amend: Tidy Up andDelete All Rows Where Cell Value Is Number

hi all,

I have the code below which is doing all I need it to do, except I would like to add a line that deletes all rows where the cell value in column "F" is a number:

Also, if anyone has any suggestions to meke it more efficiant, please feel free to make them, but the main thing is I can delete all rows if the value in column "F" is a number.

Idea Being, it:

1. Deletes all rows where value in column F is blank.
2. then Deletes all rows where value in column "F" is numeric
3. Then deleted all rows where value in column "F" is any value specified in Column A is sheet 2.

Please Login or Register  to view this content.

Many thanks in advance!

Perfect Rudi,

Thanks!