someguy,
Look into the event:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Target.Address gives you what you need.

NickHK

"someguy" <inderjitrai@yahoo.com> wrote in message
news:Xns9606EA2DC6F21inderjitraiyahoocom@216.196.97.142...
> Hi,
>
> I'm trying to write a macro that can refer to certain cells that the
> user has selected. Basically i want the user to be able to select certain
> cells and call this macro. The macro then look at each cell and if there
> is a value in the cell it add quotation marks to the value. How do I
refer
> to the range the user selected from my function/sub?
>
> TIA