search

Category: Excel VBA


Remove Interior.Color from a Range in Excel VBA

Posted by in Excel VBA

.Interior.ColorIndex = xlNone


Split first and last names in Excel VBA

Posted by in Excel VBA

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…


Workbook_Open Event Handler

Posted by in Excel VBA

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


Add A New Worksheet Using Excel VBA

Posted by in Excel VBA

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”


Add Today’s Date To A Range And Format It

Posted by in Excel VBA

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


close
search

Hi, guest!

settings

menu