Norman

Am i right in saying though this will not sort
irrespective of the + or - ?

Steve
-----Original Message-----
Hi Steve,

Ideally, any solution will be based on the strings that
appear on the above and not on the column letters (as it
is possible that they may appear in a different order
from
time to time).

The best solution for this is Excel's inbuilt sort, using
the horizontal
sort option.
This will enable you to sort the three data columns into
any column sequence
you wish and is independent of the location of the data.

If you need to perform this function in code, try
performing the operation
with the macro recorder turned on.


---
Regards,
Norman



"Steve" wrote in
message
...
I have three columns in my spreadheet.

They appear in the following order (these column names
appear in row A):
Score
FirstName
Surname

Is it possible to write a macro that will re-order these
columns so that they appear as follows:
Surname
FirstName
Score

Ideally, any solution will be based on the strings that
appear on the above and not on the column letters (as it
is possible that they may appear in a different order
from
time to time).

Many thanks
Steve


.