Bookmark page
Printable version
Course updates
|
RSS feeds
Hints and tips home » VBA hints and tips » Add A New Sheet at the end of the Workbook
Add A New Sheet at the end of the Workbook
To add a new sheet at the end of the workbook you need to count the sheets in the workbook using:
Sheets.Count
Then use this value as the rank of the sheet after which you want to add the new sheet:
Sheets.Add After:=Sheets(Sheets.Count)
Added by Carlos on 24th November 2006
More VBA hints and tips, like:
- Stop Screen Flickering When Running Code
- Display Text In a Msgbox On Multiple Lines
- Stop Display Alerts In Excel
 |
|
» Forum post: Scenario Manager |
Why would i use a scenario manager?
