Deleting a row is crieteria met.

Hi all,

I have this snippet of code


Code:
Option Explicit

Please Login or Register  to view this content.

End SubI wish to add it to this macro:

Please Login or Register  to view this content.

What I am trying to achive is that once the main part of the macro is executed I want all the rows that have a value of <100 in the column "J" to have the row deleted.

So two questions:

1.Will the snippet to delete rows work?
2.I have added into the macro code where I think it should go, is this right?


Thanks for any help that you guys can give in advance.

Remove the quotes in this line in your DeleteRows sub

Please Login or Register  to view this content.

You could put the code as indicated (but without the Sub/End Sub).
I think I would leave it as a subroutine and call it from your main code so just insert

Please Login or Register  to view this content.