Removing namd range in Excel 2007

[confusion123]

Does anyone know if there are problems re removing named ranges in Excel 2007?

I have a named range called abc which spans cells A1 to A3 on Sheet1.

This brings up a Run-time error '1004' Application-defined or object-defined error:

Names("abc").Delete

What is wrong?

 

[jimrward]

Have your tried activeworkbook.names("abc").delete

 

[chicagocomputerclasses]

There is no Names object in 2007. See below for listobject.

https://msdn.microsoft.com/en-us/library/bb210013(v=office.12).aspx

 

[confusion123]

Thanks