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" wrote in message
...
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" wrote in message
...
Hi Andi,

Try:

Up_Bound = Selection.Row


---
Regards,
Norman



"Andibevan" wrote in message
...
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" wrote in message
...
Thanks - How would I then assignt the lowerbound of the selected range to
a
value?

"Norman Jones" wrote in message
...
Hi Andi,

Try:

Up_Bound = Selection.Row


---
Regards,
Norman



"Andibevan" wrote in
message
...
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" wrote in message
...
Thanks - How would I then assignt the lowerbound of the selected range to
a
value?

"Norman Jones" wrote in message
...
Hi Andi,

Try:

Up_Bound = Selection.Row


---
Regards,
Norman



"Andibevan" wrote in
message
...
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" wrote in message
...
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" wrote in message
...
Thanks - How would I then assignt the lowerbound of the selected range to
a
value?

"Norman Jones" wrote in message
...
Hi Andi,

Try:

Up_Bound = Selection.Row


---
Regards,
Norman



"Andibevan" wrote in
message
...
Hi All,

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

Thanks

Andi