How do you adjust the macro so it works on the selected row?

I recorded a macro, but it only works on row 2, i think i see why, but how would i adjust the macro so that it works on any selected row?

Please Login or Register  to view this content.

If you apply the code tags correctly you should see your code like this before you submit the post:

[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

Dom

Thanks, try this:

Please Login or Register  to view this content.

Dom