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

3 votes302 views1 answer
Excel vba make long from two shorts
VBA
0 vote274 views1 answer
Wpf dark title bar
VBA
0 vote229 views2 answers
Vb.net include quotes in string
VBA
0 vote239 views1 answer
Vba simple quote
VBA
0 vote248 views1 answer
How to make a a msgbpx in vbs
VBA
1 vote240 views1 answer
How to remove zeros in excel
VBA
0 vote225 views1 answer
Excel vba populate array with cell values
VBA
0 vote234 views1 answer
Remove series name from legendvbnet
VBA
0 vote221 views1 answer
Excel vba center userform
VBA
5 votes249 views1 answer
Vba low byte from INTEGER
VBA