Trying to select a range prior to deleting it so i can verify correct range removed

I am enclosing a file.

In this file i am trying to delete certain rows. however, i wanted to see what rows i was deleting just before the delete so i could verify that things are working correctly. I would then remove the selection and jus tdo the the delete. But for some reason i get a runtime error when i run the enclosed file and it stops on the line where i am trying to select the row.

You need to activate the sheet (in this case Test2) before you can activate a range on the sheet.

This:

Please Login or Register  to view this content.

(line 127)

needs to have this in front of it:

Please Login or Register  to view this content.