How to get the "Target.Address" address of the selected cell?

I cant get the actual address of the cell that was selected from "Target.Address", am I going about this the wrong way?
I am getting Target from:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Is this doing what you meant it to do:

Please Login or Register  to view this content.

Thank you, that presents one of the two issues I was thinking of.
1. Passing that variable to a Sub in a module "select_by_color(sColor)".
2. Getting the address (you just solved this).

I am curious as to why you need the address in the first place. I've seen cases where people think they need to use the address when what they really need is to directly reference a cell object. Could you show more context?

My thought for the address.
The macro which user JohnTopley originally helped me with has had a row added before row 3.
Then I added more options to:

Please Login or Register  to view this content.

as

Please Login or Register  to view this content.

This causes two extra rows to be copied when I select cell "A3".
I want to use the cell address for "A3" at selection to add code to remove the two rows based on the cell selected (A3).

If cell A3 is selected, I need to remove 2 rows from another sheet where the data is being placed.

Yes and no?
It showed me how to get the address.

I see now how my question did not encapsulate the entire need.