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