Range Names - help

Is it possible to programmatically delete a range name or series of range
names?

Glen

Hi Glen

from help

---
Use Names(index), where index is the name index number or defined name, to
return a single Name object.The following example deletes the name
"mySortRange" from the active workbook.

ActiveWorkbook.Names("mySortRange").Delete
--is this what you were after?CheersJulieD"Glen Mettler"
<GlenMettler@knology.net> wrote in message
news:eEpPd.26846$2V1.18625@fe40.usenetserver.com...
> Is it possible to programmatically delete a range name or series of range
> names?
>
> Glen
>
>
>

Perfect - thanks!

Glen

"JulieD" <JulieD@hctsReMoVeThIs.net.au> wrote in message
news:%23QiqZ3REFHA.3416@TK2MSFTNGP09.phx.gbl...
> Hi Glen
>
> from help
>
> ---
> Use Names(index), where index is the name index number or defined name, to
> return a single Name object.The following example deletes the name
> "mySortRange" from the active workbook.
>
> ActiveWorkbook.Names("mySortRange").Delete
> --is this what you were after?CheersJulieD"Glen Mettler"
> <GlenMettler@knology.net> wrote in message
> news:eEpPd.26846$2V1.18625@fe40.usenetserver.com...
>> Is it possible to programmatically delete a range name or series of range
>> names?
>>
>> Glen
>>
>>
>>
>
>

you're welcome

"Glen Mettler" <GlenMettler@knology.net> wrote in message
news:BdsPd.26851$2V1.7545@fe40.usenetserver.com...
> Perfect - thanks!
>
> Glen
>
> "JulieD" <JulieD@hctsReMoVeThIs.net.au> wrote in message
> news:%23QiqZ3REFHA.3416@TK2MSFTNGP09.phx.gbl...
>> Hi Glen
>>
>> from help
>>
>> ---
>> Use Names(index), where index is the name index number or defined name,
>> to return a single Name object.The following example deletes the name
>> "mySortRange" from the active workbook.
>>
>> ActiveWorkbook.Names("mySortRange").Delete
>> --is this what you were after?CheersJulieD"Glen Mettler"
>> <GlenMettler@knology.net> wrote in message
>> news:eEpPd.26846$2V1.18625@fe40.usenetserver.com...
>>> Is it possible to programmatically delete a range name or series of
>>> range names?
>>>
>>> Glen
>>>
>>>
>>>
>>
>>
>
>
>