View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Naive question on Range naming but please answer

Selection.Name = "Test"

is indeed the most efficient and effective. It obviates the shortcoming of
not specifying the sheet name found in the other suggestions. So JE
McGimsey's suggestion is consistent, effective and highly recommended.

--
Regards,
Tom Ogilvy

"DoctorG" wrote in message
...
You have all given me varying approaches to the same issue, some more
thorough than others, instead of the Selection.Name="TEST" which is indeed
very simple yet effective, at least in this case.
You are all obviously experienced programmers so I will ask you if there

is
a need to use a more elaborate piece of code in order to achieve

consistent
results. Does the simplistic Selection.Name approach work by coincidence
here?