Formatting Numbers in Excel VBA IN THIS ARTICLE Formatting Numbers in Excel VBA How to Use the Format Function in VBA Creating a Format String Using a Format String for Alignment Using Literal Characters Within the Format String Use of Commas in a Format String Creating Conditional Formatting within the Format String Using Fractions in Formatting Strings Date and Time… Read More
How to calculate time in Excel – time difference, adding / subtracting times This tutorial focuses on various ways to calculate times in Excel. You will find a few useful formulas to add and subtract times, calculate time difference, or elapsed time, and more. In the last week’s article, we had a close look at the specificities of Excel time format and capabilities of basic time functions. Today, we are… Read More
Here’s a self-contained illustration of one way to “slice” a 2-D array from: https://stackoverflow.com/a/22769603/17357868… Read More
VBA – How to auto fit row height of merged cells in Excel How to auto fit row height of merged cells in Excel? (extendoffice.com)… Read More
INDIRECT formula to dynamically refer to another worksheet ->INDIRECT(“‘” & Sheet’s name & “‘!” & Cell to pull data from) Excel INDIRECT function – basic uses and formula examples (ablebits.com)… Read More
Benefit for learning VBA Unlike macros, VBA enables you to do the following: Work with complex logic structures (case statements, loops, and so on) Take advantage of functions and actions not available in macros Loop through and perform actions on recordsets Perform transaction processing Create database objects programmatically and work with them Create libraries of user-defined functions Call Windows… Read More
ParamArray The ParamArray keyword allows you to accept a dynamic number of arguments.The word ParamArray is an abbreviation for parameter array.Instead of using a large number of optional parameters it might be better to use a parameter array instead.This can only be used as the last argument in a procedure or function.This keyword cannot be used with ByRef,… Read More