Delete entire row if cell contains the string X

excel vba excel-2010 excel-2007
AnchovyLegend picture AnchovyLegend · Jul 12, 2013 · Viewed 287.9k times · Source

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!

Answer

MBK picture MBK · Jul 12, 2013

This is not necessarily 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

Related questions

Excel how to find values in 1 column exist in the range of values in another

I have two columns- column A which extends upto 11027(values) and column I which extends to 42000(values).Both the columns contains some code details. Something like this A B q123 as124 as124 gh456 ff45 q123 dd1 dd2 xx2 xx3 xx4 …

Read More
filter out multiple criteria using excel vba

I have 8 variables in column A, 1,2,3,4,5 and A, B, C. My aim is to filter out A, B, C and display only 1-5. I can do this using the following code: My_Range.AutoFilter Field:=1, Criteria1:=Array("1", "2", "3","4","5"), _ Operator:=xlFilterValues But …

Read More
Excel: the Incredible Shrinking and Expanding Controls

Occasionally, I'll happen across a spreadsheet which suffers from magic buttons or listboxes which get bigger or smaller over time. Nothing in the code is instructing this. Has anybody else experienced this joy?

Read More