When the user selects cells, these can be accessed via the Selection range
property, such as
For Each cell In Selection
'do stuff on cell
Next cell
--
HTH
RP
(remove nothere from the email address if mailing direct)
"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
Bookmarks