From: mp on 23 Sep 2009 12:11
Thanks will also check the addin
"Rick Rothstein" <rick.newsNO.SPAM(a)NO.SPAMverizon.net> wrote in message
> However, if you wish to do this the "macro" way, this is how you would
> iterate through the Names collection...
> Dim N As Name
> For Each N In Application.Names
> Debug.Print N.Name & " ==> " & N.RefersTo
> Just address the appropriate properties of each iterated name as needed.
> Rick (MVP - Excel)
> "Rick Rothstein" <rick.newsNO.SPAM(a)NO.SPAMverizon.net> wrote in message
>> Forget using a macro.... download Jan Karel Pieterse's NameManager
>> Add-In... it will allow you to do lots of things with Defined Names.
>> After you install it, it will be available in the Tools item on the Menu
>> Bar. To rename a Defined Name, just double click it in the NameManager
>> Rick (MVP - Excel)
>> "mp" <nospam(a)Thanks.com> wrote in message
>>> Hi all,
>>> How to loop through range names?
>>> range names like menu Insert| name | define
>>> similar to intention of (invalid) pseudocode below
>>> For each range in Worksheet.Ranges
>>> Debug.Print range.name
>>> since i don't find a ranges collection the above won't work
>>> the reason i ask is i had named some ranges inconsistently and wanted to
>>> run a quick macro to fix them
>>> should be
First | Prev |
Pages: 1 2
Prev: OO4O execute a query against Oracle, VBA Excel 2003
Next: External Data