ExcelBanter - How do I add a new TAB ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I add a new TAB ? (https://www.excelbanter.com/excel-worksheet-functions/105605-how-do-i-add-new-tab.html)

ramym

How do I add a new TAB ?

Bearacade

How do I add a new TAB ?

Tab, as in Sheet tab? as in a new Worksheet??

If so, Go to insert, Worksheet

--
Bearacade

------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=572738

How do I add a new TAB ?

' Add new sheet
Sheets.Add
'Select new sheet
Sheets("Sheet1").Select
'Change name of new sheet
Sheets("Sheet1").Name = "Candidates"

HTH

All times are GMT +1. The time now is 07:35 AM.