Range Names - help
 

Is it possible to programmatically delete a range name or series of range
names?

Glen

Range Names - help
 

Hi Glen

from help

---
Use Names(index), where index is the name index number or defined name, to
return a single Name object.The following example deletes the name
"mySortRange" from the active workbook.

ActiveWorkbook.Names("mySortRange").Delete
--is this what you were after?CheersJulieD"Glen Mettler"
wrote in message
.. .
Is it possible to programmatically delete a range name or series of range
names?

Glen

Range Names - help
 

Perfect - thanks!

Glen

"JulieD" wrote in message
...
Hi Glen

from help

---
Use Names(index), where index is the name index number or defined name, to
return a single Name object.The following example deletes the name
"mySortRange" from the active workbook.

ActiveWorkbook.Names("mySortRange").Delete
--is this what you were after?CheersJulieD"Glen Mettler"
wrote in message
.. .
Is it possible to programmatically delete a range name or series of range
names?

Glen

Range Names - help
 

you're welcome

"Glen Mettler" wrote in message
...
Perfect - thanks!

Glen

"JulieD" wrote in message
...
Hi Glen

from help

---
Use Names(index), where index is the name index number or defined name,
to return a single Name object.The following example deletes the name
"mySortRange" from the active workbook.

ActiveWorkbook.Names("mySortRange").Delete
--is this what you were after?CheersJulieD"Glen Mettler"
wrote in message
.. .
Is it possible to programmatically delete a range name or series of
range names?

Glen