Basics of VBA / Macros Chapter – 63 (Function and Sub Part-1)
Function and Sub The difference between a function and a sub in Excel VBA is that a function can return a value while a sub cannot. Functions and subs become…
Read article →Category Archives: Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
Basics of VBA / Macros Chapter – 62 (Arrays Part-5)
Basics of VBA / Macros Chapter – 62 (Arrays Part-5)
Size of an Array To get the size of an array in Excel VBA, you can use the UBound and LBound functions. Place a command button on your worksheet…
Read article →Basics of VBA / Macros Chapter – 61 (Arrays Part-4)
Basics of VBA / Macros Chapter – 61 (Arrays Part-4)
Month Names Below we will look at a program in Excel VBA which creates a User Defined Function that uses the Array function to return the names of the…
Read article →Basics of VBA / Macros Chapter – 60 (Arrays Part-3)
Basics of VBA / Macros Chapter – 60 (Arrays Part-3)
Array Function The Array function in Excel VBA can be used to quickly and easily initialize an array. Place a command button on your worksheet and add the following code…
Read article →Basics of VBA / Macros Chapter – 59 (Arrays Part-2)
Basics of VBA / Macros Chapter – 59 (Arrays Part-2)
Dynamic Array If the size of your array increases and you don't want to fix the size of the array, you can use the ReDim…
Read article →Basics of VBA / Macros Chapter – 58 (Arrays Part-1)
Basics of VBA / Macros Chapter – 58 (Arrays Part-1)
Array An array is a group of variables. In Excel VBA, you can refer to a specific variable (element) of an array by using the array name and the…
Read article →Combine All Excel Files in a Folder with Power Query (No VBA, No Copy-Paste)
Combine All Excel Files in a Folder with Power Query (No VBA, No Copy-Paste)
Use Excel’s Power Query “From Folder” to merge every workbook or CSV in a folder into one table that refreshes with one click —…
Read article →Basics of VBA / Macros Chapter – 57 (Events Part-6)
Basics of VBA / Macros Chapter – 57 (Events Part-6)
Rolling Average Table Below we will look at a program in Excel VBA that creates a rolling average table. Place a command button on…
Read article →Basics of VBA / Macros Chapter – 56 (Events Part-5)
Basics of VBA / Macros Chapter – 56 (Events Part-5)
Bills and Coins Below we will look at a program in Excel VBA that splits an amount of money into bills and coins. Situation:…
Read article →Basics of VBA / Macros Chapter – 55 (Events Part-4)
Basics of VBA / Macros Chapter – 55 (Events Part-4)
Create a Footer Before Printing Below we will look at a program in Excel VBA that creates a footer before printing a workbook. Create…
Read article →Basics of VBA / Macros Chapter – 54 (Events Part-3)
Basics of VBA / Macros Chapter – 54 (Events Part-3)
Highlight Active Cell Below we will look at a program in Excel VBA that highlights the row and column of the Active Cell (selected…
Read article →Basics of VBA / Macros Chapter – 53 (Events Part-2)
Basics of VBA / Macros Chapter – 53 (Events Part-2)
BeforeDoubleClick Event Code added to the Worksheet BeforeDoubleClick Event will be executed by Excel VBA when you double click a cell on a worksheet.…
Read article →