Assuming Rng is your range...

UpperLeftCellAddress = Rng(1).Address

LowerRightCellAddress = Rng(Rng.Count).Address

LeftCol = Rng(1).Column

RightCol = Rng(Rng.Count).Column

TopRow = Rng(1).Row

BottomRow = Rng(Rng.Count).Row

--
Rick (MVP - Excel)


"MikeZz" wrote in message
...
Can someone point me to a set of functions or properties for set ranges?
Specifically I'm looking for the following:

For a range of cells:
Upper & Lower Left Cell Address
Upper & Lower Right Cell Address

Left & Right Column Number
Top & Bottom Row Number

These are probably just properties of a range object but I can't seem to
find them in help... I know it's probably one of those "it's so easy a
Caveman could do it" things that I'm just missing.

Thanks
MikeZz