Excel Is Fun

Excel Magic Trick 1489

DESCRIPTION In this video learn how to create a single Excel formula that will lookup a product price and lookup the volume / quantity discount and deliver the correct discounted Product Price. See how to [Read More >>>]

Excel Is Fun

Excel Magic Trick 1488

DESCRIPTION Vote For Favourite Formula to Lookup Correct Price Based on Effective Date WORKBOOKS

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 Is Fun

Excel Magic Trick 1487

DESCRIPTION In this video learn how to Lookup the correct product price based on the latest Effective Date. The Lookup table has multiple listings of the product, each with a different effective date and price. [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 Is Fun

Excel Magic Trick 1486

DESCRIPTION In this video learn how to Lookup the correct product price based on the latest Effective Date. The Lookup table has multiple listings of the product, each with a different effective date and price. [Read More >>>]

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 Is Fun

Excel Magic Trick 1485

DESCRIPTION In this video learn how to Lookup the correct product price based on the latest Effective Date. The Lookup table has multiple listings of the product, each with a different effective date and price. [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 >>>]