Hi Bob -
I've got a roughly similar problem. In my application I'm building some
macros for customized cut and paste functions. (I'm NOT interested in the
value in the cells)

if the user selects one cell, (the active cell) l've been able to use;
row=activecell.row and col=activecell.column
in order to build statements like:
range(cells(row,col),cells(row+var1,col+var2).select

My problem is that I've not been able to figure out from the Excel docum in
range properties how to get the row and column "coordinates" when the user
has selected part of a column, A1:A9 for example, or more importantly,
a "traditional" range like B2:E9

how do I get the upper left and lower right row and column numbers for the
cells that 'define' a user selected range?

Many thanks,
Neal Zimm




"Bob Phillips" wrote:

> 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
>
>
>