I am new to VBA and I am trying to come up with a way to delete all rows (and shift cells up, if possible) where the website column cell contains the word none. The table contains 5000+ records and this would save me a great amount of time.

I appreciate any suggestions. Many thanks in advance!5ano1d

 

Best Answer :

This is not a VBA task – This specific task is easiest sollowed with Auto filter.

1.Insert Auto filter (In Excel 2010 click on home-> (Editing) Sort & Filter -> Filter)
2. Filter on the ‘Websites’ column
3. Mark the ‘none’ and delete them
4. Clear filter

🙂

 http://stackoverflow.com/questions/17606045/delete-entire-row-if-cell-contains-the-string-x