<div>
I would rename the Sheet's code name and use that.in the code<br />
<br />
You can refer to the sheet by it's Index number i.e it's position in the sheet but that's not reliable.<br />
<br />
See this<br />
<br />
<a href="http://excel-it.com/excel_sheet_names.html" rel="ugc">http://excel-it.com/excel_sheet_names.html</a>
</div>


I would rename the Sheet's code name and use that.in the code

You can refer to the sheet by it's Index number i.e it's position in the sheet but that's not reliable.

See this

http://excel-it.com/excel_sheet_names.html [http://excel-it.com/excel_sheet_names.html]

<div>
thanks Norie, so simple when you know how.
</div>


thanks Norie, so simple when you know how.

<div>
<div class="content wysiwyg-content">
I would normally open a sheet in Excel using Sheets(&quot;Name of sheet&quot;).Select<br />
<br />
But is it possible to open a sheet if I don't know the name of the sheet ][because the user changes the name ] but I know it is always on Sheet5<br />
<br />
Thanks
</div>
</div>


I would normally open a sheet in Excel using Sheets("Name of sheet").Select

But is it possible to open a sheet if I don't know the name of the sheet ][because the user changes the name ] but I know it is always on Sheet5

Thanks

vba to open a sheet if I don't know name of sheet

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.