View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
mp mp is offline
external usenet poster
 
Posts: 70
Default 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