This line of code will sort the entire first column while leaving the header
row as it is.

Range("a:a").Sort Key1:=Range("A2"), Order1:=xlAscending, Header:=xlYes

This command will not affect data in adjacent columns.  If you wish to sort
column a with other data, you should change the Range("a:a") part to
something that matches your range (like Range("a:e") or something).

HTH,
Matthew Pfluger

Before sorting, you must be sure that the table is properly formatted. If,
for instance, you have something like:

Some Mexican Stocks               
A Date               
Mark    CoTicker    CoName    PriceHi    PriceLow
1    VTO    Vitro    7    5
2    GELEF    Elektra    15    6
3    TMX    TELMEX    10    2

All attempts to sort the data will fail, because it is not clear which cells
form the table you want to sort. Although Excel functions have error-handlers
routines that can solve the error or ambiguity, it is better to state things
clearly. In your example, the error-handler is trying to solve the error by
including the title cell.

In my example, there must be an EMPTY row between the title of the table and
the data.

Some Mexican Stocks               
A Date               
               
Mark    CoTicker    CoName    PriceHi    PriceLow
1    VTO    Vitro    7    5
2    GELEF    Elektra    15    6
3    TMX    TELMEX    10    2

As a general comment, I think it is better to state things clearly than
state them in a confusing way (either for others or for the machine), and
then fix them with another routine. By adding an extra routine or extra code
the whole task becomes more complex.