You don't need a macro to do this.


1. Add your temporary column
2. Define the order you want the rows indexed
3. Sort the table on the temporary column
4. Remove the temporary table

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/