Thanks again!!! ;)

Nigel Wrote:
Glad to help - sorry we missed the point. As when I discovered th
codename
property a lot of prior problems I had with users changing tab names
dissappeared. The other benefit is that you can use the sheet codenam
as a
reference to the object directly....

mySheet.Cells(1,2)
mySheet.Range("A1:C20").Sort Sortkey1:=mySheet.Range("A1")

etc.....

and of course the sheetname property is still available for keeping th
user
informed about the sheet tabs they see and change!

--
Cheers
Nigel



"T-®ex" wrote i
message
...

Dear Nigel,

Thanks for your help!!!

You kept referring to 'codename'... I never realized there really i
a
CodeName property in VBA (you have to forgive me... i'm still a
novice...) - that it is the '(Name)' property!!!

You've been a great help!!!

Thanks again!!!

Got ideas now!!! :)


--
T-®ex

------------------------------------------------------------------------
T-®ex's Profile:
http://www.excelforum.com/member.php...o&userid=26572
View this thread
http://www.excelforum.com/showthread...hreadid=399687


--
T-®e
-----------------------------------------------------------------------
T-®ex's Profile: http://www.excelforum.com/member.php...fo&userid=2657
View this thread: http://www.excelforum.com/showthread.php?threadid=39968