Inefficient code

I use an enumeration to do this.

As applications are developed, the positions of particular columns in tables may change as columns are added, deleted, or rearranged. Hard-coding the column positions in VBA makes it very difficult to accommodate such changes. An alternative is to use a private enumeration at the top of the module that operates on the sheet, like this

Please Login or Register  to view this content.

Then in the body of the code,

Please Login or Register  to view this content.

If not specified, the value of the first item in an enumeration is zero, so the xxx is just an unused placeholder so I don't have to explicitly set the value of the first column to 1 (in the example, Desc = 1). If the first column of the table were D, change the first item to xxx = 3.

These good things happen:

• IntelliSense works; type Col. and you see a list of column names after you type the period
• If the column numbers get rearranged, just change the order of appearance in the enumeration to match
• Because the scope of the enumeration is limited to the particular module, you can use the same enumeration name in different modules, with different item names (or some of the same item names in different positions, if appropriate)

What's the relationship between the array and your worksheet layout??...