I tried it in a black workbook and it didn't do anything. I defined strSheetName and still did not get it to do anything.

I have to put this code inside a FOR loop, so I can not end a sub or start a new function in the middle of it. I appreciate you help, thank you.

maybe i am not understanding correctly?

The code that I posted is just a portion of my code to do one thing. I got it to jump to the correct sheets, and now just need to put it in the right row instead of the bottom of the sheet.