for a single area:

msgbox Selection.Address(0,0)

--
Regards,
Tom Ogilvy


"John" wrote in message
...
If macro starts with a selected area (by mouse) how do you get the
corner cells of the selected area? In other words obtain the cell:cell
form.

Thanks