I have learned from this site that there is the worksheet name as it appears on the tab and the index that is the tab number and finally the internal object name that is unchangable by the user. This is the name that appears in first in the Visual basic list of objects next to the parenthetical tab name.
My questions are: what is this name called?
How do I get this name from sheets(1).??? or worksheets(2).???
how can I refer to this name in code without hard coding it? I know I can write sheet1.vaue = xxx but I want to write variablename.??? where the value of variable is