<div>
Since VBA starts with 1 instead of 0, the below statement will return the name of the first sheet<br />

<pre><code id="code-20-41212905-1">Public Function GetFirstSheet() As String
    GetFirstSheet = Application.Sheets.Item(1).Name
End Function</code></pre>
</div>


Since VBA starts with 1 instead of 0, the below statement will return the name of the first sheet


Public Function GetFirstSheet() As String
    GetFirstSheet = Application.Sheets.Item(1).Name
End Function

<div>
<div class="content wysiwyg-content">
How can I use vba to find the name of the first sheet in a workbook?<br />
I use this code to copy from the first sheet to another sheet in the workbook: <br />
Sheets(&quot;Sheet1&quot;).Range(&quot;b1<wbr />0:d10&quot;).Co<wbr />py Sheets(&quot;Sales&quot;).Range(&quot;B2&quot;<wbr />) <br />
<br />
What I want is to use some vba code to return name of the first sheet in the workbook to a vaiable that I can use in the code. Something like this:<br />
strFirstSheet = &quot;somehow find name of first sheet&quot; <br />
Sheets(strFirstSheet).Rang<wbr />e(&quot;b10:d10<wbr />&quot;).Copy Sheets(&quot;Sales&quot;).Range(&quot;B2&quot;<wbr />) <br />
<br />
Maybe a strange problem but it makes sense in my setting. Appreciate any help.
</div>
</div>


How can I use vba to find the name of the first sheet in a workbook?
I use this code to copy from the first sheet to another sheet in the workbook: 
Sheets("Sheet1").Range("b10:d10").Copy Sheets("Sales").Range("B2") 

What I want is to use some vba code to return name of the first sheet in the workbook to a vaiable that I can use in the code. Something like this:
strFirstSheet = "somehow find name of first sheet" 
Sheets(strFirstSheet).Range("b10:d10").Copy Sheets("Sales").Range("B2") 

Maybe a strange problem but it makes sense in my setting. Appreciate any help.

Use VBA to find the name of the first sheet in a workbook

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.