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
.
|