Working With Worksheets in Excel VBA
Select a Specific Worksheet Worksheets(“Expenditure 2016”).Select Refer to the Active Worksheet Using ActiveSheet ActiveSheet.Range(“A10”).Interior.ColorIndex = 7 Activate a Worksheet Worksheets(“Sheet1”).Activate Create a New Worksheet/s Worksheets.Add before:=Worksheets(“Sheet4”), Count:=5 Name a Worksheet Name the active sheet ActiveSheet.Name = “New Name” Name a specific sheet Worksheets(“Expenditure 2016 Draft”).Name = “Expenditure 2016 Final” Change a Worksheet’s Tab Colour Worksheets(“Sheet1”).Tab.ColorIndex… Read More »Working With Worksheets in Excel VBA