Shane
Sat Mar 15 09:35:16 CDT 2008
This is a multi-part message in MIME format.
------=_NextPart_000_0031_01C8866F.1CCF5220
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Howard,
I know you are not using 2007 but an FYI - In 2007 you can filter the =
"broken" names. Formulas, Name Manager, Filter, Names with Errors. (or =
Names without Errors). Then you can delete these in one step.
If what you are trying to do is list the dead names as indicated below =
in <2007, then use the Paste List command and apply an Auto Filter, and =
go from there.
Cheers,
Shane Devenshire
Microsoft Excel MVP
"Howard Kaikow" <kaikow@standards.com> wrote in message =
news:OxsiDwphIHA.748@TK2MSFTNGP04.phx.gbl...
> "Jim Cone" <jim.coneXXX@rcn.comXXX> wrote in message
> news:%23yyDWxihIHA.4880@TK2MSFTNGP03.phx.gbl...
>>
>> Insert | Name | Paste | Paste List (button)
>> Not exactly what you wanted but...
>=20
> I have code that creates a list of names, but Paste List does show the =
dead
> names (names with broken references).
> I'll change the macro to list the dead names.
>=20
>
------=_NextPart_000_0031_01C8866F.1CCF5220
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dunicode">
<META content=3D"MSHTML 6.00.6000.16609" name=3DGENERATOR></HEAD>
<BODY id=3DMailContainerBody=20
style=3D"PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-TOP: 15px"=20
bgColor=3D#ffffff leftMargin=3D0 topMargin=3D0 CanvasTabStop=3D"true"=20
name=3D"Compose message area">
<DIV><FONT face=3DArial size=3D2>Hi Howard,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I know you are not using 2007 but an =
FYI - In 2007=20
you can filter the "broken" names. Formulas, Name Manager, Filter, =
Names=20
with Errors. (or Names without Errors). Then you can delete =
these in=20
one step.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>If what you are trying to do is list =
the dead names=20
as indicated below in <2007, then use the Paste List command and =
apply an=20
Auto Filter, and go from there.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Cheers,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Shane Devenshire</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Microsoft Excel MVP</FONT></DIV>
<DIV><BR><BR>"Howard Kaikow" <kaikow@standards.com> wrote in =
message=20
news:OxsiDwphIHA.748@TK2MSFTNGP04.phx.gbl...<BR>> "Jim Cone"=20
<jim.coneXXX@rcn.comXXX> wrote in message<BR>>=20
news:%23yyDWxihIHA.4880@TK2MSFTNGP03.phx.gbl...<BR>>><BR>>> =
Insert |=20
Name | Paste | Paste List (button)<BR>>> Not exactly what you =
wanted=20
but...<BR>> <BR>> I have code that creates a list of names, but =
Paste List=20
does show the dead<BR>> names (names with broken references).<BR>> =
I'll=20
change the macro to list the dead names.<BR>> =
<BR>></DIV></BODY></HTML>
------=_NextPart_000_0031_01C8866F.1CCF5220--