delete a category

A

achan

I have created a few categories, i used a code inspired of the code
below, to put some functions in but ....
How to delete or rename the categories I have created ???

Thanks for your help.



Lcat = 14
Do
Lcat = Lcat + 1
Application.ExecuteExcel4Macro _
"DEFINE.NAME(""Djzh" & Lcat & """,0,2,,," & Lcat & ")"
cat = Names("Djzh" & Lcat).Category
Loop While cat <> "User Defined" And cat <> CatName

If cat = "User Defined" Then
Application.ExecuteExcel4Macro _
"DEFINE.NAME(""Djzh" & Lcat & """,0,2,,,""" & CatName & """)"
End If

For i = 1 To NbFuncs
Application.MacroOptions FctName(i), FctDesc(i), , , , , Lcat
Next i

For i = 15 To Lcat
Application.ExecuteExcel4Macro "DELETE.NAME(""Djzh" & i & """)"
Next i
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top