Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|