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
A few years’ ago I created a video showing you how to create an animated Christmas tree. See the video here https://www.bluepecantraining.com/portfolio/created-a-christmas-tree-with-sparkling-lights-in-excel/ It’s Christmas time again and I thought it was time to create version 2.0 to include an automated countdown to Christmas and animated tree and stars, all on a Christmassy background. Watch the… Read More »Countdown to Christmas in Excel with Christmas Tree & Lights
Have you ever wondered what Excel’s #NUM! error actually means? The #NUM! error can appear for several reasons: here are three of the most likely. Reason 1: You are Performing an Impossible Calculation in Excel If you perform an impossible calculation in Excel you will get the #NUM! error. An example of an impossible calculation… Read More »Excel’s #NUM! Error – What Does it Mean?