Excel VBA

.Interior.ColorIndex = xlNone

When data is formatted like this: Colbert, Mike test@test.com BAIS IS And you want it like this: Mike Colbert test@test.com BAIS IS Sub dataCleanUp() Dim name As String Dim email As String Dim major As String Dim track As String Dim i As Integer ‘ loop counter Dim nStudents As Integer ‘ row counter Dim … Read more

Open the ThisWorkbook code window: Private Sub Workbook_Open() wsInstructions.Activate End Sub

Add a new worksheet named “Mike”… Worksheets.Add.Name = “Mike” Add a new worksheet named “Mike” as the first worksheet, before all the other worksheet tabs… Worksheets.Add(Before:=Worksheets(1).Name = “Mike” Add a new worksheet named “Mike” as the last worksheet, after all the other worksheet tabs… Worksheets.Add(Before:=Worksheets(Worksheets.Count).Name = “Mike”

With Range(“A1”) .Value = Date ‘use today’s date ‘format it, you can also use yyyy for a four digit year. .NumberFormat = “mm/dd/yy” End With