DELTE RANGE NAMES

[gus]

I want to deletye range names

 

[Tom Ogilvy]

dim nm as name
for each nm in Thisworkbook.Names
nm.delete
Next

 

[Jan Karel Pieterse]

Hi,

If you choose Insert, name, define, you'll get a dialog
that has a delete button.

If you use defined names a lot, consider downloading the
Name manager (by Charles Williams, Matthew Henson and
myself) from:

www.bmsltd.co.uk/mvp

or from:

www.decisionmodels.com/downloads.htm


Regards,

Jan Karel Pieterse
Excel TA/MVP