select columns B to the last column. Then do

Data=sort
Select options button and choose left to right.

Specify your row of dates as the key field (assume row 1)

--
Regards,
Tom Ogilvy

"Jim Brass" wrote in message
...
Hi
This may be simple: I have a sheet that has the dates Jan 1 thru Dec 31 in
column A. Then in columns B on out I have years 1890 - 2005. I have the
high
temps for each day in each of the years columns(Col B is 1890; Col C is
1891;etc.). I would like to reverse the order from 1890-2005 to 2005-1890.
(eg. Col B - 2005; Col C - 2004) What macro would work the best? Thanks,
Jim