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

8 votes247 views1 answer
Vba convert 2 bytes to an integer
VBA
0 vote188 views1 answer
Excel vba DisplayAlerts
VBA
0 vote175 views1 answer
Vba file size
VBA
0 vote177 views1 answer
Convert number to minutes in vba
VBA
22 votes242 views1 answer
Excel vba check if directory exists
VBA
1 vote148 views1 answer
How to open cmd with vbd
VBA
0 vote185 views1 answer
Excel filter by date not working vba
VBA
0 vote245 views1 answer
Vba vbcrlf chr
VBA
0 vote185 views1 answer
Excel vba copy range with filter
VBA
0 vote184 views1 answer
Check if cell is dbnullvb.net
VBA