Excel Macro Class

Microsoft Excel lets you create your own custom functions, which are generally called user defined functions (UDFs). These are Function proc...

Arrays are used to store sets of data. A range with data in Excel can be stored in a two-dimensional (2D) array. A column or row are also Ra...

In a previous post we have seen how to sort text or words inside a single cell in the Excel worksheet using VBA macros. But that approach w...