Manipulation and Analysis of Data Sets with VBA
Michael J. Rees · 2018
This chapter focuses on the use of VBA in the manipulation and analysis of data sets. It represents the integration and consolidation of some necessary techniques within the specific context of data analysis. One of the reasons to use VBA to manipulate or analyse data sets is that VBA can detect the size of a data set, and conduct its operations accordingly. By contrast, if the size of a data set changes, then Excel functions that refer to this data would generally need to be adapted as well as copied to additional cells. The use of the CurrentRegion property of a cell or range is one very important tool in this respect. One may wish to automate the process of inspecting a worksheet to detect the data range. Important tools in this respect are those that detect the used range and the last cell that is used in a worksheet.