Easy Excel Macros

How can I add a new line IN A MESSAGE BOX?

You can use vbCrLf. vbCrLf stands for VB Carriage Return Line Feed. MsgBox "Line 1" & vbCrLf & "Line 2" It puts a return and a new line as shown in the message box below. Posted on January 19, 2013 by easy excel macros

how can I get the sheet names of an Excel file?

In order to display all the sheet names of an excel file we need to know how many sheets the excel file contains. In Excel VBA we can use the for each..next loop for this. Dim exampleSheet As Worksheet For Each exampleSheet In Worksheets MsgBox exampleSheet.Name Next exampleSheet result: Posted on February 5, 2013 by easy excel macros

How can I delay a macro?

To wait a certain amount of time before executing the macro use this simple code. Application.Wait Now + TimeValue("00:00:5") MsgBox ("5 sec has elasped") Posted on February 16, 2013 by easy excel macros

how can I disable errors showing up in Excel vba?

The following code line will allow Excel VBA to continue the next code line upon hitting an error. On Error Resume Next example: On Error Resume Next Range("").Value = 3 Range("A1").Value = 2 As a result the incorrect code line will be ignored and only a value of 2 will be placed into Cell A1. Posted on February 26, 2013 by easy excel macros

How can I select a range from the active cell to the last entry in a column or a row?

Example: To select a range from the active cell tot the last entry in a column or a row use the following VBA code. Range(ActiveCell, ActiveCell.End(xlToRight).Select Result: You can use xlToLeft, xlUp and xlDown for the other directions. Posted on March 4, 2013 by easy excel macros