getting runtime error for current range macro

First of all, you don't actually need to select in the code.

Second, if you can describe what you are trying to accomplish that would help.

If you remove .select, the code is fine.

Basically - you cannot select anything what is not on the currently active sheet. So either:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

or of course

Please Login or Register  to view this content.

You don't select like that

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

Also, you have to be on that sheet in order for this to work

Glad you have found a solution that will work for you. You're welcome and We are happy to help.