for each ar in Selection.Areas
msgbox ar(1).Address
Next

--
Regards,
Tom Ogilvy

"geoff" wrote in message
...
Hi
If there are 3 unnamed ranges on sheets(1)say B3:B5,
C6:C10 and E10:E13 how can I get the address of the first
cell in each range?


thanks