About Us

LSB[_3_]

Hi,

May I know how should i write the code in Macro to delete
all the cell name that i have created? I have a very long
list of cell names when i see it from Insert - Names -
Define. Instead of manually go there and delete, i would
like to write the code to delete it. Please help. Thanks.

Regards,
SeoK Bee

Christof DB

Hi the

for each n in Names
n.delete
next n

christof

-----Original Message-----
Hi,

May I know how should i write the code in Macro to
delete
all the cell name that i have created? I have a very
long
list of cell names when i see it from Insert - Names -
Define. Instead of manually go there and delete, i would
like to write the code to delete it. Please help. Thanks.

Regards,
SeoK Bee
.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Deleting code from a macro (by a macro)	Brettjg	Excel Discussion (Misc queries)	2	May 8th 07 10:14 PM
Deleting cell data without deleting formula	Tom Hall	Excel Discussion (Misc queries)	4	October 29th 06 04:07 PM
Macro Help Needed: Comparing cell values and deleting rows	[email protected]	Excel Discussion (Misc queries)	1	September 19th 06 02:39 AM
Deleting a macro	scottech	Excel Discussion (Misc queries)	5	December 5th 05 05:02 PM
how prevent formula in cell from deleting when deleting value????	sh-boom	New Users to Excel	1	September 30th 05 06:12 PM

Menu

About Us