Okay then, I've just done this in a workbook with named ranges. Try it
like this:

For Each nme In ActiveWorkbook.Names : nme.Delete : Next nme

Copy this into the immediate window, then press <enter - it worked
for me.

Hope this helps.

Pete

On May 22, 2:56*pm, GOH wrote:
I copied your instruction over, so shouldn't have missed out anything.



"Pete_UK" wrote:
Just check that you have typed everything in correctly, including the
spaces.

Hope this helps.

Pete

On May 21, 3:26 pm, GOH wrote:
I followed your instruction but it resulted in an error "run-time error
'1004': that name is not valid."- Hide quoted text -

- Show quoted text -