VBA String Functions: Left, Mid, InStr, Replace, Split and More
Excel VBA course lesson 8: clean and reshape text with VBA — Len, Left, Right, Mid, InStr, InStrRev, Replace, Trim, UCase/LCase, StrConv, Split/Join, Like…
Read article →Atul Vij
VBA Error Handling and Debugging: On Error, Breakpoints and the Immediate Window
VBA Error Handling and Debugging: On Error, Breakpoints and the Immediate Window
Excel VBA course lesson 7: read VBA error messages, step through code with F8, use breakpoints, the Immediate and Locals windows, Debug.Print, and handle…
Read article →DSTDEV Function in Excel: Sample SD of Matching Records
DSTDEV Function in Excel: Sample SD of Matching Records
DSTDEV returns the sample standard deviation of a field for matching records. Like all D-functions it uses a database range and a criteria range…
Read article →VBA Loops Explained: For, For Each, Do While and Do Until
VBA Loops Explained: For, For Each, Do While and Do Until
Excel VBA course lesson 6: repeat work with For…Next, Step, For Each over ranges and sheets, Do While/Until loops, Exit For, nested loops and…
Read article →RANK Function in Excel: The Old Ranking Function
RANK Function in Excel: The Old Ranking Function
RANK still works for compatibility and behaves exactly like RANK.EQ. New workbooks should use RANK.EQ or RANK.AVG.
Read article →5 Handy VBA Macros: Mod, Second Highest, Sum by Colour and Delete Blank Rows
5 Handy VBA Macros: Mod, Second Highest, Sum by Colour and Delete Blank Rows
Excel VBA course lesson 5: five small, reusable macros explained line by line — every Nth row with Mod, second-highest value, sum by fill…
Read article →Decisions in VBA: If…Then, And/Or and Select Case
Decisions in VBA: If…Then, And/Or and Select Case
Excel VBA course lesson 4: make macros decide with If…Then…Else, ElseIf, And, Or and Not, check empty and error cells, and replace long If…
Read article →DPRODUCT Function in Excel: Multiply Values Matching Criteria
DPRODUCT Function in Excel: Multiply Values Matching Criteria
DPRODUCT multiplies the values of a field for matching records (rarely needed; e.g. compounding growth factors). Like all D-functions it uses a database range…
Read article →Format Cells with VBA: Fonts, Colours, Borders and Number Formats
Format Cells with VBA: Fonts, Colours, Borders and Number Formats
Excel VBA course lesson 3: format reports with VBA — fonts, fill colours with RGB, borders, alignment, number formats for Indian rupees and dates,…
Read article →BYROW Function in Excel: Apply a Calculation to Each Row
BYROW Function in Excel: Apply a Calculation to Each Row
BYROW runs a LAMBDA on each row of an array and returns one result per row — row totals, row maximums, row checks.
Read article →Working with Ranges in Excel VBA: Cells, Offset, Resize and More
Working with Ranges in Excel VBA: Cells, Offset, Resize and More
Excel VBA course lesson 2: refer to cells with Range and Cells, find the last row and column, move with Offset, grow selections with…
Read article →Excel VBA Variables and Data Types: A Practical Guide
Excel VBA Variables and Data Types: A Practical Guide
Excel VBA course lesson 1: open the VBA editor, write your first macro, declare variables with Dim, choose the right data type (Long, Double,…
Read article →