Sheet1/Sheets(1)/Sheets("sheet1")

[lezawang]

Hi
I have one sheet in a workbooks, and that sheet I can call it

1) Sheet1
2) Sheets(1) or Worksheets(1)
3) Sheets("sheet1") or Worksheets("sheet1")

Sheet1, Sheets("sheet1") or Worksheets("sheet1") will always refer to that sheet no matter what except if the sheet name has been changed then only Sheet1 will refer to that sheet

Sheets(1) or Worksheets(1), will always refer to that sheet unless its tab physically move to different location.

So Sheet1 will always refer to that sheet no matter what, if name is changed or location. So I can use that name in my code to avoid any problem from changing name and location. Am I right

 

[JoeMo]

Right with respect to tab name changes or tab order changes. Excel assigns code names in the format Sheetn where n = 1,2,3,.... depending on the order in which the sheet was created. It is possible to change the code name directly on the VBA Properties menu for the sheet where it's listed as (Name).

 

[lezawang]

wow so happy to know I can change the codeName as well. Thank you so much.

 

[JoeMo]

You're welcome. I posted an edit to my initial reply while you were posting post #3 . Go back and read the edited post #2 . I had forgotten that the CodeName property of a sheet is read only. That limits changing the code name to using the VBA properties window for the sheet.

 

[Norie]

You should use Sheets(1) as that will refer to the only sheet in the workbook even if it's tab name or codename has been changed.