EXCEL 2000 - NAME BOX

ckaye

New Member
Joined
Jan 27, 2005
Messages
4
How does one "batch delete" names in a worksheet ?

I have a workbook with 6 worksheets linking and now I have to rename the name fields therefore deleting what was previously there .. I have been doing it individually but this is quite monotonous .. I would prefer to delete and start over but if there is a simpler way .. then I am open to suggestion! Thank you!
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
ckaye,

WELCOME to the Board!!

This will delete the names.
Code:
For Each nnn In ActiveWorkbook.Names 
   nnn.Delete 
Next
using "search" on top of the page you will find other examples using Names

kind regards,
Erik
 

ckaye

New Member
Joined
Jan 27, 2005
Messages
4
Thank you Erik but if I read your response correctly this will only delete one at a time .. what I want to do is basically highlight all then delete all .. CK
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
There doesn't exist a macro method to delete them all at once.
But this macro will delete all names in very very short time...

kind regards,
Erik
 

ckaye

New Member
Joined
Jan 27, 2005
Messages
4

ADVERTISEMENT

Thanks again Erik .. I will try that method .. CK
 

ckaye

New Member
Joined
Jan 27, 2005
Messages
4
Thank you Tazguy .. I downloaded ASAP ... will give it a try .. CK
 

Watch MrExcel Video

Forum statistics

Threads
1,122,464
Messages
5,596,288
Members
414,052
Latest member
Dual Showman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top