Deleting Names From Workbook (VBA)

Hello,

I have a little code as part of a macro that once it arrives starts to delete the names in the workbook one by one.
This worked a treat for some time, but seems that something has changed and when running returns a runt time error 1004.

Please Login or Register  to view this content.

For some reason the code seems to skip setting the nm at line 1, then gets to line 4 and returns the error. If i skip this line and continue onto line 5 the nm is set and then the loop continues without a problem.

Any body out there that might know where i am going wrong here?

Thanks in advance!

Is that the whole code? Works fine for me...

No not the whole code there is quite a lot before this, from what i can tell when it gets there looking at the locals is that the very first name in the workbook seems to have a problem

there are 100 odd names in the workbook and the one at index 2 should be the first name as far as i can tellCapture.PNG

ok will post now tks.
Sorry no my version is now 2010... need to update that will get to that in moment.

data.xlsm
ok here is the file

You could try

Please Login or Register  to view this content.

and see if this works better.

Alf

Thanks Alf that has sorted the issue

You are welcome.

Thanks for feedback and rep

Alf