Change code to look for current worksheet?

I need help changing code to look for the current worksheet. Excel is looking for the worksheet I used while creating the macro.

This is what the code currently looks like:

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Please read post number 3 from me or read the forum rules to find out about code tags. Thanks!

Hie dalewms2,

Please go to your first post, click Edit, then click Go Advanced. Select all of your code and then click the # symbol which will wrap your code.

Thanks dalewm2! To change a thread to solved, you go back to your first post, click Edit and then Go Advanced again except now you'll find Title and No Prefix located in a drop down menu. Select that and you'll see the word "Solved". Select solved and then save your post.

Hi dalewms2, if your thread is solved you will need to start a new thread with a new title depicting your new problem.