I missed the first part of the thread but, does this help:

Mid(Selection.Address, InStr(Selection.Address, ":") + 1,
Len(Selection.Address) - InStr(Selection.Address, ":"))

Steve


"Neal Zimm" <nealzimm@yahoo.com> wrote in message
news:A534C557-5010-4E05-9CB4-E1333E797167@microsoft.com...
> Thanks, much, and I HATE being a pest like this, but what about the cell
> in
> the lower right? I need to know the 'size' of the selected range. Since
> I
> wrote you this morning, I tried the loop you mentioned to 'someguy' and
> was
> able to make each cell the activecell and use the max function to trap the
> highest row and column values but I'm hopeful there's a better way. I'll
> see what Excel has on the keyword 'selection' in the interim.
> Thanks in advance, again,
> Neal Z
>
>
> "Bob Phillips" wrote:
>
>> Neal,
>>
>> When you have a multi-cell selection, just get the first cell, like
>>
>> row = Selection.Cells(1,1).Row
>>
>> col = Selection.Cells(1,1).Column
>>
>> --
>