Hello All, Hope someone can help...

I have a table in excel, range: c11:h584 where row C11:H11 contains th
titles.
What I would like to do is automatically sort the column by row G.

I may want to change the macro to sort on different columns - is i
possible to build this into the macro using a msgbox (for example)

Is there a way to automate this sort function ?

Many thanks for your help.
Regards

Scott

--
scottwilson
-----------------------------------------------------------------------
scottwilsonx's Profile: http://www.excelforum.com/member.php...fo&userid=1112
View this thread: http://www.excelforum.com/showthread.php?threadid=26272