Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help With Formula For Cell Addresses | Excel Worksheet Functions | |||
Strange cell addresses | Excel Discussion (Misc queries) | |||
E-Mail Addresses in Cell | Links and Linking in Excel | |||
Cell addresses | Excel Discussion (Misc queries) | |||
cell addresses | Excel Worksheet Functions |