Deleting a row is crieteria met.

[Lensmeister]

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.

[barryleajo]

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.