Vbnet add new ecel sheet

Dim ExcelWorkSheet As Excel.Worksheet = CType(ExcelWorkBook.Sheets.Add(Count:=1), Excel.Worksheet)
'Add(Count:=1) means that 1 additional sheet is added, on top of the existing sheet that is automatically generated

'This defines the sheets sperately, so they may be manipulated
Dim ExcelWorkSheetPasswords As Excel.Worksheet = CType(ExcelWorkBook.Sheets(1), Excel.Worksheet)
Dim ExcelWorkSheetArchive As Excel.Worksheet = CType(ExcelWorkBook.Sheets(2), Excel.Worksheet)

Similar codes

0 vote236 views1 answer
Show unix time in vba
VBA
0 vote227 views1 answer
Vba dropdown event
VBA
0 vote261 views1 answer
Vba listbox remove all items
VBA
0 vote249 views1 answer
Vba add shape oval
VBA
0 vote276 views1 answer
Vba userform textbox wrap text
VBA
-1 vote246 views1 answer
How to correct a number to 2 decimal places in vba
VBA
0 vote247 views1 answer
How to set location and size of new from vb
VBA
0 vote279 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote238 views2 answers
Delete all controls from list of control vb.net
VBA
0 vote237 views1 answer
Vba timestamp -- milliseconds
VBA