How to get the current sheet number of a workbook?
If you have multiple worksheets in your workbook, do you have any good ideas to get the current sheet number excepting to count them one by one? In this article, I will talk about an easy trick for you to return the active worksheet’s number as you need.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
With the following simple VBA code, you can quickly get the active worksheet number as you want, please do as follows:
1. Activate the worksheet which you want to return its index number.
2. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.
3. Click Insert > Module, and paste the following code in the Module Window.
VBA code: Get the current sheet number
Sub GetActiveSheetIndex() MsgBox ActiveSheet.Index End Sub
4. Then press F5 key to run this code, and you will get the index number of current worksheet in a popping message box as following screenshot shown:
Recommended Productivity Tools