Excel VBA command (2)

Worksheet

Command	Description
1. Sheets(“Sheet1”).Select	Select “Sheet1”
2. Sheets(1).Select	Select sheet index no. 1 (count from left hand side)
3. Sheets(Array("Sheet1","Sheet2")).Select	Select “Sheet1” and “Sheet2” together
4. Sheets("Sheet1").Visible=xlVeryHidden	Hide “Sheet1”, not found in menu Format > Sheet
5. ActiveWindow.SelectedSheets.Visible= False	Hide selected sheet together
6. Sheets(“Sheet1”).Delete	Delete “Sheet1”
7. Sheets.Count	Return number of sheets in this workbook
8. Sheets.Add	Insert 1 sheet
9. Sheets.Add Before:=Sheets("Sheet1")	Insert 1 sheet before “Sheet1”
10. Sheets.Add After:=Sheets(“Sheet1”)	Insert 1 sheet after “Sheet1”
11. Sheets.Add After:=Sheets(Sheets.Count)	Insert 1 sheet at last sheet
12. Sheets("Sheet1").Copy Before:=Sheets(2)	Copy “Sheet1” and insert before sheet index no. 2
13. Sheets("Sheet1").Copy After:=Sheets(2)	Copy “Sheet1” and insert after sheet index no. 2
14. Sheets(“Sheet1”).Name = “Test”	Rename sheet name from “Sheet1” to “Test”
15. Sheets(1).Name = “Test”	Rename sheet index no. 1 to “Test”
16. ActiveSheet.UsedRange.Columns.count	Return number of columns used in active sheet
17. ActiveSheet.UsedRange.Rows.count	Return number of rows used in active sheet
18. ActiveSheet.Protect	Protect active sheet from any changes in active sheet
19. ActiveSheet.Unprotect	Unprotect active sheet from any changes in active sheet