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 vote202 views1 answer
Add items to combobox vb.net
VBA
3 votes258 views2 answers
Excel "vba" match last value
VBA
4 votes212 views1 answer
Vba create directory
VBA
1 vote2K views1 answer
Vba Remove Case Sensitivity
VBA
18 votes544 views2 answers
Vba make word from bytes
VBA
6 votes229 views1 answer
Excel vba isalpha
VBA
0 vote215 views1 answer
Excel vba extract year
VBA
0 vote218 views1 answer
Excel delete ever other vba
VBA
0 vote202 views1 answer
Vba add month to date
VBA
-1 vote201 views1 answer
For i in range vba
VBA