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?
|