Clear Multiple Range Names

[Smurfit-Stone]

Hello Board,

I need a macro to clear multiple range names. I thought this was a real easy one I could do myself, but once I typed all the range names in the macro wouldn't work and wouldn't tell me why. I put the range names in quotes within parenthese...the whole nine yards.

I have 13, range names I need to clear, can someone tell me how to type in all 13 (or a shortcut) and get the thing to work. Thanks in advance.

 

[Armando Montes]

Ty this:

Sub DelNames()
    For Each n In ActiveWorkbook.Names
          n.Delete
    Next n
End Sub

 

[Smurfit-Stone]

Thanks, so much, but will this delete the range names themselves or just clear the contents of the range names? I just want to clear the content of the range names. Thanks again