clear rows meeting criteria - vba help!

[HimThruMe]

i need to write code that clears the entire row if it has the word "backordered" in the N Column.

any suggestions?

 

[schielrn]

Do you really need to use vba for this? you can use autofilter and filter on column N for "backordered" and then clear out all the cells?

Otherwise you could record a macro doing that task? But if you really must need a vba apporach please post back and I will write something up.

Hope that helps.

 

[HimThruMe]

i need it in vba because it occurs (among other things) at the click of a button... all the backordered data is being copied and moved to another page using this code here:

Range("BOInvoice").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _
"n3:n4"), CopyToRange:=Range("a21:l48"), Unique:=False

the problem is that it only copies it... i need it to remove it from the original range ("BOInvoice") after it moves it... i cant seem to find the option of cut the data and pasting it using the advanced filter... any suggestions?

 

[Joe4]

Duplicate:
http://www.mrexcel.com/forum/showthread.php?t=430885