delete a bunch of named ranges

[Takeadoe]

Gang,

I've created a bunch of named ranges and I'd like to delete a bunch of
them. Is anyone aware of an easy way to delete them en mass? The
one-at-a-time method is painfully slow when we're talking about a
couple hundred.

Thanks in advance...


Mike

[Gord Dibben]

Visit JK Pieterse's site and download his Name Manager Add-in

http://www.jkp-ads.com/


Gord Dibben MS Excel MVP

On 29 Jun 2006 18:41:58 -0700, "Takeadoe" <[email protected]> wrote:

>Gang,
>
>I've created a bunch of named ranges and I'd like to delete a bunch of
>them. Is anyone aware of an easy way to delete them en mass? The
>one-at-a-time method is painfully slow when we're talking about a
>couple hundred.
>
>Thanks in advance...
>
>
>Mike

[Takeadoe]

Got it! Thank you Very Much!
Gord Dibben wrote:
> Visit JK Pieterse's site and download his Name Manager Add-in
>
> http://www.jkp-ads.com/
>
>
> Gord Dibben MS Excel MVP
>
> On 29 Jun 2006 18:41:58 -0700, "Takeadoe" <[email protected]> wrote:
>
> >Gang,
> >
> >I've created a bunch of named ranges and I'd like to delete a bunch of
> >them. Is anyone aware of an easy way to delete them en mass? The
> >one-at-a-time method is painfully slow when we're talking about a
> >couple hundred.
> >
> >Thanks in advance...
> >
> >
> >Mike