This tutorial shows how to use Kode Magd to generate the VBA that is my column tracker class.
What is a column tracker class?
it’s a class that will store the column name and column position, when you want to know which position a column is in it’ll just return a position.
What are the advantages?
There are two main advantages.
- Moving columns in source file. When you receive a source file we like to think that the positions of the columns is fixed, but unfortunately it’s very normal for upstream systems to change. And so sometimes a column might move position.
- Readability. Hard coding column positions into our VBA is the fastest thing to initially type but by far the worst thing to maintain. Because this class uses the text at the top of the column, the VBA that is written referencing this class will be much easier to read.