Auto delete a line?

[schlepers]

How would you make a macro that would delete the line if a field in that line say for example K1:K100 had "XX" or "XXX" in it?

[VBA Noob]

Do a quick search on forum for examples or see link

http://www.rondebruin.nl/delete.htm

VBA Noob

[Stuie]

Hi schlepers,

A quick and easy way of doing this would be to loop all the cells, check the values and then delete if need be.

This code should do the job:

Please Login or Register  to view this content.

I havnt had chance to check this code so look out for a glitch or a little tweak, but the basic idea is there

[schlepers]

thx. Let me check them out.

j--

[schlepers]

How would you do it with:

with this if you want to fill in the Firstrow and let the code find the Lastrow in the column.

Please Login or Register  to view this content.

Where it automatically figures out the last line instead of the range value?

[Stuie]

yea you could do that or you could write a loop to check if the active cell is the last in a list but if the list goes into its 1000's a loop could take a while

[schlepers]

I wanted to add this into a sorting Macro. I can't seem to make it work, I'm doing it wrong?

[VBA Noob]

schlepers,

Please read forum rules below. All code needs to be wrapped as I did on your first post

VBA Noob

[Stuie]

one peice of the code that needs correcting would be the

Please Login or Register  to view this content.

when using Or/And in IF block you need to re compair like so:
(i have highlighted the change)

Please Login or Register  to view this content.

[schlepers]

I wanted to add this into a sorting Macro. I can't seem to make it work, I'm doing it wrong?

Please Login or Register  to view this content.

[schlepers]

I gete an error when I run above for some reason??