Range Defined names loop
"Patrick Molloy" wrote in message
...
its definitely not a good idea to use keywords for variables. yuo use
range
as a Range object...
absolutely, that was just pseudocode to show the idea
for each <rangeobject in <rangesobject
dim cell as range
then use the variable called cell
to check a "name" you could use
debug.print Range("A1").Name.Name
this will raise an error if there is no name, so
for each cell in Selection
on error resume next
debug.print cell.Address(False,False), Cell.Name.Name
on error goto 0
next
thanks i'll give it a try
mark
|