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

4 votes197 views1 answer
Excel vba check cell not empty
VBA
0 vote196 views1 answer
Vba code to select image in sheet
VBA
0 vote189 views1 answer
Dynamically change drop down list visual basic
VBA
0 vote207 views3 answers
Write to text file vb.net
VBA
0 vote198 views1 answer
Sendkeys vba selenium
VBA
0 vote210 views1 answer
Vba multiple optional arguments
VBA
0 vote213 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote195 views1 answer
Xlbycolumns is not declared
VBA
0 vote189 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA
0 vote158 views1 answer
How to sort datagridview in vb.net
VBA