Delete Rows with certain data

[n3tw0rkadm1n1strat0r]

I've tried this code to filter out the rows that contain certain data:

objExcel.Range("A:A").Entirerow.Delete '4 = "Data"

But it ends up deleting everything!

 

[PHV]

But it ends up deleting everything
As expected.
What is the difference for you between "filter out" and "delete" ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[n3tw0rkadm1n1strat0r]

Sorry, I meant that I want to delete any rows that contain the word "Data" or maybe two or three words "Data1,Data2,Data3".

 

[n3tw0rkadm1n1strat0r]

Does that make sense PHV?

 

[n3tw0rkadm1n1strat0r]

Any ideas?

 

[n3tw0rkadm1n1strat0r]

Sorry just trying to figure this out...do I have to make a selection when doing this or is what I have right and I just need to fix a couple things?