Change "With Selection" so you don't need to select cells to see the change?

[Xcutioner]

This code works when the cells are selected, could someone help me change

Please Login or Register  to view this content.

to use this code without the need to select any cells?

Please Login or Register  to view this content.

[rorya]

What cells do you want it to apply to?

[rorya]

Based on your cross-post, you want:

Please Login or Register  to view this content.

I suggest you read the forum rules on cross-posting and follow them in future, please.

[Xcutioner]

I would love to but I got this message when I was trying to use links: You are not allowed to post any kinds of links, images, or videos until you post a few times. Thanks, I will try this out!

[Xcutioner]

Please Login or Register  to view this content.

Solution to my problem, from SO.

[rorya]

Which is what I suggested earlier.