Referencing a sheet name

[westonkw]

When you are writing code you can reference a sheet by "Sheet1" or by its name at the bottom of the workbook on the tabs. The "Sheet1" ref. always stays with the sheet but the name at the bottom can be changed and it screws up the code if the sheet gets renamed.

Im trying to reference a sheet in a formula by the "Sheet1" name, is this possible? I cant get it to work. I need to do this because I have a macro that add sheets when the user needs them, and they also rename them, usually the date. Then in the certain situation it gives me a ref error in theses cells when the sheet is renamed. If the "Sheet1" reference would work in the formula this would take care of the problem.

[Rick_Stanich]

If the sheets will remain in the same order of precedence then try "Sheets(1)" in place of "Sheets("Sheet1")" and so on.
Example:

MsgBox Sheets(1).Range("A1").Value

Will display the value in cell A1 of the first work sheet.