Data Lists

This chapter shows you how to set up VBA code to manage data in lists, and code to filter and sort information in lists. The features examined are:

Sorting

Tables (called Lists in Excel 2003)

AutoFilter

Advanced Filter

Data Forms

As always, you can use the macro recorder to generate some basic code for these operations. However, the recorded code needs modification to make it useful, and the recorder can even generate erroneous code in some cases. You will see that dates can be a problem, if not handled properly, especially in an international setting.

You will also see that there is more than one way to perform some tasks. Because Excel has introduced new objects that manage, filter, and sort data, there has been some duplication of the features of older objects. This can be confusing, but it does give you a wide choice of options that you can tailor to fit your needs.

0 0

Post a comment