VBA – Filters and Reporting AutoFilter is applicable to a column or a set of columns. It filters data depending on the given criteria. The …
Continue ReadingVBA – Events
VBA – Events Events and Event Procedures were introduced in Excel97. Earlier versions of Excel do not support events. An Event is an action initiated …
Continue ReadingVBA- Arrays
VBA- Arrays An array is a way to store more than one value with a common name. By definition, “An array is a group of variables …
Continue Reading