Prev: OO4O execute a query against Oracle, VBA Excel 2003
Next: External Data
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
news:OHmAmJCPKHA.352(a)TK2MSFTNGP02.phx.gbl...
> 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
> Next
>
> 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
> news:OKfv%23GCPKHA.508(a)TK2MSFTNGP06.phx.gbl...
>> 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
>> list.
>>
>> http://www.oaltd.co.uk/DLCount/DLCount.asp?file=NameManager.zip
>>
>> --
>> Rick (MVP - Excel)
>>
>>
>> "mp" <nospam(a)Thanks.com> wrote in message
>> news:%23bSnt%23$OKHA.508(a)TK2MSFTNGP06.phx.gbl...
>>> 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
>>> next
>>>
>>> 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
>>> eg
>>> labor00
>>> labor2001
>>> ...
>>> should be
>>> labor2000
>>> labor2001
>>> ...
>>> thanks
>>> mark
>>>
>>
>


First  |  Prev  | 
Pages: 1 2
Prev: OO4O execute a query against Oracle, VBA Excel 2003
Next: External Data