cell addresses
 

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

cell addresses
 

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

cell addresses
 

thank you
-----Original Message-----
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





.