Upperbound of Selected Range

Hi All,

An easy one - how do I assign the upper row number of the selected range to
the value Up_Bound?

Thanks

Andi

Hi Andi,

Try:

Up_Bound = Selection.Row


---
Regards,
Norman



"Andibevan" <[email protected]> wrote in message
news:%[email protected]...
> Hi All,
>
> An easy one - how do I assign the upper row number of the selected range
> to
> the value Up_Bound?
>
> Thanks
>
> Andi
>
>

Thanks - How would I then assignt the lowerbound of the selected range to a
value?

"Norman Jones" <[email protected]> wrote in message
news:[email protected]...
Hi Andi,

Try:

Up_Bound = Selection.Row


---
Regards,
Norman



"Andibevan" <[email protected]> wrote in message
news:%[email protected]...
> Hi All,
>
> An easy one - how do I assign the upper row number of the selected range
> to
> the value Up_Bound?
>
> Thanks
>
> Andi
>
>

Hi Andi,

The first row cis returned by:

Selection.Row

The last row is returned by:

Selection.Row + Selection.Rows.Count - 1


---
Regards,
Norman



"Andibevan" <[email protected]> wrote in message
news:[email protected]...
> Thanks - How would I then assignt the lowerbound of the selected range to
> a
> value?
>
> "Norman Jones" <[email protected]> wrote in message
> news:[email protected]...
> Hi Andi,
>
> Try:
>
> Up_Bound = Selection.Row
>
>
> ---
> Regards,
> Norman
>
>
>
> "Andibevan" <[email protected]> wrote in
> message
> news:%[email protected]...
>> Hi All,
>>
>> An easy one - how do I assign the upper row number of the selected range
>> to
>> the value Up_Bound?
>>
>> Thanks
>>
>> Andi
>>
>>
>
>
>

Assuming a single area selection.

Up_Bound = selection.rows(selection.rows.count).row

Lower_Bound = selection.Row

--
Regards,
Tom Ogilvy

"Andibevan" <[email protected]> wrote in message
news:[email protected]...
> Thanks - How would I then assignt the lowerbound of the selected range to
a
> value?
>
> "Norman Jones" <[email protected]> wrote in message
> news:[email protected]...
> Hi Andi,
>
> Try:
>
> Up_Bound = Selection.Row
>
>
> ---
> Regards,
> Norman
>
>
>
> "Andibevan" <[email protected]> wrote in
message
> news:%[email protected]...
> > Hi All,
> >
> > An easy one - how do I assign the upper row number of the selected range
> > to
> > the value Up_Bound?
> >
> > Thanks
> >
> > Andi
> >
> >
>
>
>

Thanks Norman - I had been trying to use UBOUND() and LBOUND() but to no
avail.

Ta

Andi


"Norman Jones" <[email protected]> wrote in message
news:%[email protected]...
Hi Andi,

The first row cis returned by:

Selection.Row

The last row is returned by:

Selection.Row + Selection.Rows.Count - 1


---
Regards,
Norman



"Andibevan" <[email protected]> wrote in message
news:[email protected]...
> Thanks - How would I then assignt the lowerbound of the selected range to
> a
> value?
>
> "Norman Jones" <[email protected]> wrote in message
> news:[email protected]...
> Hi Andi,
>
> Try:
>
> Up_Bound = Selection.Row
>
>
> ---
> Regards,
> Norman
>
>
>
> "Andibevan" <[email protected]> wrote in
> message
> news:%[email protected]...
>> Hi All,
>>
>> An easy one - how do I assign the upper row number of the selected range
>> to
>> the value Up_Bound?
>>
>> Thanks
>>
>> Andi
>>
>>
>
>
>