Excel VBA

Excel VBA Type Declarations

January 12, 2016 0

Excel VBA Introduction Part 34 – Type Declarations DESCRIPTION The Type statement in VBA allows you to define your own static data structures which you can then use in your variable declarations. This video explains […]

Excel Is Fun

Excel Magic Trick 1187

January 11, 2016 0

Formula to Lookup Every 5th Item In a Column, INDEX and ROWS functions DESCRIPTION See how to create a formula to Lookup Every 5th Item In a Column using INDEX and ROWS functions.

Excel Quick Tip

Unable to open file. The file is corrupted

January 7, 2016 0

If you get this message “Unable to open file. The file is corrupted” when you try and open an Excel file you have downloaded from a website or received in an email try the following […]

Dueling Excel

Dueling Excel 58

January 6, 2016 0

Sorting Formula For Biggest Sales and Sales Rep Names with Ties DESCRIPTION See Mr Excel and excelisfun create formulas for sorting biggest to smallest (descending) numbers that can deal with ties, then sort the sales […]

Excel VBA

Excel VBA Creating Add Ins

January 5, 2016 0

Excel VBA Introduction Part 33 – Creating Add Ins DESCRIPTION Creating an Excel VBA Add-In is a great way to make your custom functions available to other Excel workbooks and VBA projects. This video teaches […]

Excel Is Fun

Excel Magic Trick 1186

January 4, 2016 0

Extract Color From Description Field & Create Revenue by Color PivotTable DESCRIPTION See how: (00:09) Problem Setup (01:04) Barry Houdini at Mr Excel Message Board and pmsocho at YouTube (01:23) SEARCH function with a Function […]

Dueling Excel

Dueling Excel 57

December 30, 2015 0

Extract Many Years from Just Two Years DESCRIPTION See Mr Excel and excelisfun take the text string “1997-2000” and create a row of years consisting of 1997, 1998, 1999, 2000. See the functions LEFT, RIGHT, […]

Excel VBA

Excel VBA ADO (ActiveX Data Objects) SQL Statements

December 29, 2015 0

Excel VBA Introduction Part 32 – ADO (ActiveX Data Objects) SQL Statements DESCRIPTION The ADO Command object essentially allows you to write SQL statements directly into your VBA code and execute them on whichever database […]