Macro báo lỗi sheets ws_count select
Skip to main content This browser is no longer supported. Show Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. Sheets.Add method (Excel)
In this articleCreates a new worksheet, chart, or macro sheet. The new worksheet becomes the active sheet. Syntaxexpression.Add (Before, After, Count, Type) expression A variable that represents a Sheets object. Parameters
Return valueAn Object value that represents the new worksheet, chart, or macro sheet. RemarksIf Before and After are both omitted, the new sheet is inserted before the active sheet. ExampleThis example inserts a new worksheet before the last worksheet in the active workbook.
This example inserts a new worksheet after the last worksheet in the active workbook, and captures the returned object reference in a local variable.
Note In 32-bit Excel 2010, this method cannot create more than 255 sheets at one time. Support and feedbackHave questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback. Additional resources
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. 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.
To run the macro, position the insertion point in the line that reads "Sub WorksheetLoop()," and press F5. 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.
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. ReferencesFor 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 Need more help? |