Excel VBA

Excel VBA 1.5

See How This window allows you to directly test some VBA code. So let’s start, type the following into the console: ?Worksheets. Select .Count in the list or directly type .Cout to obtain : ?Worksheets.Count [Read More >>>]

Excel VBA

Excel VBA 1.4

See How 3: Type the following code in the new module : Sub hello()      MsgBox “Hello World !”End Sub

Excel VBA

Excel VBA 1.3

The procedure describes how to add an Object library reference, and afterwards how to declare new variables with reference to the new library class objects. The example below shows how to add the PowerPoint library [Read More >>>]

Excel VBA

Excel VBA 1.2

To explicitly declare variables in VBA, use the Dim statement, followed by the variable name and type. If a variable is used without being declared, or if no type is specified, it will be assigned the [Read More >>>]

Excel VBA

Excel VBA 1.1

Step 1: Open a Workbook Step 2 Option A: Press  Alt  +  F11 This is the standard shortcut to open the VBE. Step 2 Option B: Developer Tab –> View Code First, the Developer Tab [Read More >>>]

Excel VBA

Find The Last Occupied Row

You can use the following code to find the last row in a worksheet that contains data and assign it to a variable. If you use or are planning to use VBA frequently then it [Read More >>>]