Skip to main content. Microsoft 365; Office; Windows; Surface; Xbox; Deals; Support. It will give you two years of coverage for device malfunctions, drops, spills, and other accidental damages on the device. This is available for devices purchased within 45 days of purchase, but you can contact Microsoft Support or drop by a Microsoft Store to check if the service can still be added to your Surface Laptop. Share your workbook with others and always work on the latest version for real-time collaboration to help get work done faster. With Microsoft 365, work within an Excel file from mobile, desktop, and web. Jun 10, 2020 Disclaimer STOCKHISTORY is currently available to 100% of Microsoft 365 Subscribers on Mac, Windows, and Excel Online. Excel is introducing a dynamically updating service-backed function that builds on the flexibility of dynamic arrays and fills a gap in the Stocks data type by providing access to.
Summary
This article contains a Microsoft Visual Basic for Applications macro (Sub procedure) that loops through all the worksheets in the active workbook. This macro also displays the name of each worksheet.
More Information
Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. To try the sample macro, follow these steps:
Type the following macro code into a new module sheet.
Windows 10 64 bit size on usb. To run the macro, position the insertion point in the line that reads 'Sub WorksheetLoop(),' and press F5.
Microsoft Workbook Laptop Download
The macro will loop through the workbook and display a message box with a different worksheet name each time it runs through the loop. Note that this macro will only display worksheet names; it will not display the names of other types of sheets in the workbook.
You can also loop through all of the worksheets in the workbook by using a 'For Each' loop.
Enter the following macro code into a new module sheet.
To run the macro, position the insertion point in the line that reads 'Sub WorksheetLoop2(),' and press F5.
This macro works identically to the WorksheetLoop macro, except that it uses a different type of loop to process all of the worksheets in the active workbook.
References
For additional information about getting help with Visual Basic for Applications, please see the following article in the Microsoft Knowledge Base:
163435 VBA: Programming Resources for Visual Basic for Applications
226118 OFF2000: Programming Resources for Visual Basic for Applications
In MicrosoftExcel, a workbook is a collection of one or more spreadsheets, also called worksheets, in a single file. Below is an example of a spreadsheet called 'Sheet1' in an Excel workbook file called 'Book1.' Our example also has the 'Sheet2' and 'Sheet3' sheet tabs, which are also part of the same workbook.
Difference between a workbook, worksheet, and spreadsheet
Enter the following macro code into a new module sheet.
To run the macro, position the insertion point in the line that reads 'Sub WorksheetLoop2(),' and press F5.
This macro works identically to the WorksheetLoop macro, except that it uses a different type of loop to process all of the worksheets in the active workbook.
References
For additional information about getting help with Visual Basic for Applications, please see the following article in the Microsoft Knowledge Base:
163435 VBA: Programming Resources for Visual Basic for Applications
226118 OFF2000: Programming Resources for Visual Basic for Applications
In MicrosoftExcel, a workbook is a collection of one or more spreadsheets, also called worksheets, in a single file. Below is an example of a spreadsheet called 'Sheet1' in an Excel workbook file called 'Book1.' Our example also has the 'Sheet2' and 'Sheet3' sheet tabs, which are also part of the same workbook.
Difference between a workbook, worksheet, and spreadsheet
Because the terms spreadsheet, workbook, and worksheet are so similar, there may be some confusion when trying to understand their differences. When you open Microsoft Excel (a spreadsheet program), you're opening a workbook. A workbook can contain one or more different worksheets that can be accessed through the tabs at the bottom of the worksheet your currently viewing. What's often most confusing is that a worksheet is synonymous with a spreadsheet. In other words, a spreadsheet and worksheet mean the same thing. However, most people only refer to the program as a spreadsheet program and the files it creates as spreadsheet files.
How to create a new workbook
To create a new workbook in Microsoft Excel, follow the steps below for your version of Excel.
Microsoft Excel 2013 and later
- Open Excel.
- Click the File tab.
- Click New.
- Click Blank workbook.
Microsoft Excel 2010
- Open Excel.
- Click the File tab at the top of the window.
- Click New
- Click Blank workbook.
Microsoft Excel 2007
Best Microsoft Laptop Computers
- Open Excel.
- Click the Office Button
- Select Blank and recent.
- In the right pane, double-click Blank workbook.
Related pages
Free Excel Workbook
Spreadsheet, Spreadsheet terms
