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