basic conversion of cell address to a range

Originally Posted by Marc L

. . . The standard of your work likes superfluous maintenance and does very not rule the rest of the world ‼ . . .

1st debatable, 2nd granted.

. . . when an user may change the sheet name or the sheets order, . . .

Workbook protection prevents renaming worksheets. Since formulas calling INDIRECT with references to worksheets other than the one containing the formulas would also be adversely affected by arbitrarily renamed worksheets, generally a good idea to protect workbooks. As for worksheet order, if worksheets can't be renamed, how could Worksheets("some_name") be rendered invalid? If worksheet foo originally appeared as the 1st in a workbook, would moving it to the middle or end affect Worksheet("foo")?

Granted codenames can be changed, but Sheet11 (Sheet follwed by a positive integer) isn't descriptive.