Make Code Work on Any Sheet in a Workbook

[Modify_inc]

How can I retype the following so I can copy it into a different sheet without having to rename the sheet name? Currently, I have to rename the Worksheet name in the code to the current sheet name. I would much prefer it worked in any sheet I move it to. I created this using a macro, so I assume that is why it defaulted to this worksheet name.

Please Login or Register  to view this content.

[Fluff13]

If you want it to work on the active sheet, change every instance of

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[Logit]

.
Try replacing :

Please Login or Register  to view this content.

with :

Please Login or Register  to view this content.

[Modify_inc]

.
Try replacing :

Please Login or Register  to view this content.

with :

Please Login or Register  to view this content.

That was quick! I will try it shortly, thanks again!

[Fluff13]

But not as quick as me

[Modify_inc]

But not as quick as me

lol, I just realized that. You guys must live here or something. Just changed it and tested it successfully! Thank you both!

[Fluff13]

Glad we could help & thanks for the feedback

[Logit]

.
Glad we could help.

Fluff :
My computer is setup to monitor your activity. When you post a reply ... my computer waits 60 seconds then sends a copy
of what you've posted.

Just sayin ...

[Fluff13]

[sintek]

You guys are so funny...Needed that lol...

[jolivanes]

Re: But not as quick as me
Maybe "But not as quick as I"

[Fluff13]

who cares?
Me, Myself & I all share one thing in common.

They's all ME

[jolivanes]

Re: who cares?
Not me. I just struck me for someone from Chippenham

[sintek]

Proper use of English language Important is not...Important the ability to code is...