Hi
Selection.Address

will give you the address as a textstring.
NOTE:
If this string is long (more than 1024 characters, possibly less?) -
which occurs if there are lots of pieces in the selection, it can be
difficult to put this address back into a range object

e.g. Range(Selection.Address)

can give an error. In that case, you have to break the string up and
use Union to get the range back.
I have several functions for dealing with address strings if you need
them.
regards
Paul

michael.beckinsale wrote:
Hi All,

I have a situation where l need the user to select a multiple range of
cells in a single column by holding down the 'Ctrl' key and selecting
the cells. The cells are not likely to be contiginous.

Can anybody provide the code (or point me in the right direction) to
retrieve the cell addresses / rows once the selection has been made?

TIA

Regards

Michael Beckinsale