How do I delete all named ranges in a sheet at one time?

How do I delete all named ranges in a sheet at one time rather than having to
delete them one at a time?
--
L.Wall

There are lots of names that you may not want to delete (excel creates some
hidden ones that are important.)

Get a copy of Jan Karel Pieterse's (with Charles Williams and Matthew Henson)
Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

And you'll be able to pick and choose nicely.

L.Wall wrote:
>
> How do I delete all named ranges in a sheet at one time rather than having to
> delete them one at a time?
> --
> L.Wall

--

Dave Peterson

There are lots of names that you may not want to delete (excel creates some
hidden ones that are important.)

Get a copy of Jan Karel Pieterse's (with Charles Williams and Matthew Henson)
Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

And you'll be able to pick and choose nicely.

L.Wall wrote:
>
> How do I delete all named ranges in a sheet at one time rather than having to
> delete them one at a time?
> --
> L.Wall

--

Dave Peterson

For Each nme In Activeworkbook.Names
nme.Delete
Next nme

--

HTH

RP
(remove nothere from the email address if mailing direct)


"L.Wall" <john_doe@hotmail.com> wrote in message
news:CE7B4821-D836-4274-A24B-016315703A8D@microsoft.com...
> How do I delete all named ranges in a sheet at one time rather than having
to
> delete them one at a time?
> --
> L.Wall

For Each nme In Activeworkbook.Names
nme.Delete
Next nme

--

HTH

RP
(remove nothere from the email address if mailing direct)


"L.Wall" <john_doe@hotmail.com> wrote in message
news:CE7B4821-D836-4274-A24B-016315703A8D@microsoft.com...
> How do I delete all named ranges in a sheet at one time rather than having
to
> delete them one at a time?
> --
> L.Wall

There are lots of names that you may not want to delete (excel creates some
hidden ones that are important.)

Get a copy of Jan Karel Pieterse's (with Charles Williams and Matthew Henson)
Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

And you'll be able to pick and choose nicely.

L.Wall wrote:
>
> How do I delete all named ranges in a sheet at one time rather than having to
> delete them one at a time?
> --
> L.Wall

--

Dave Peterson

For Each nme In Activeworkbook.Names
nme.Delete
Next nme

--

HTH

RP
(remove nothere from the email address if mailing direct)


"L.Wall" <john_doe@hotmail.com> wrote in message
news:CE7B4821-D836-4274-A24B-016315703A8D@microsoft.com...
> How do I delete all named ranges in a sheet at one time rather than having
to
> delete them one at a time?
> --
> L.Wall