<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6249.1">
<TITLE>Array sorting</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Hi Listers,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I have a single dimension array of excel cell references stored as string values. I was wondering how you can sort a range that is say A1:C3 from A1, A2, A3, B1… C3 to A1, B1, C1, A2, B2…C3? Any help would be greatly appreciated.</FONT></P>
<BR>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">regards</FONT></SPAN>
</P>
<P><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">David</FONT></SPAN>
</P>
<P><SPAN LANG="en-us"><B><FONT COLOR="#008080" SIZE=1 FACE="Tahoma">----------------------------------------------------</FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT COLOR="#008080" SIZE=1 FACE="Tahoma">David Powell</FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT COLOR="#008080" SIZE=1 FACE="Tahoma">Computing Support Officer</FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT COLOR="#008080" SIZE=1 FACE="Tahoma">Worsley Alumina Pty Ltd</FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT COLOR="#008080" SIZE=1 FACE="Tahoma">Bauxite Mine</FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT COLOR="#008080" SIZE=1 FACE="Tahoma">Boddington WA 6390</FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT COLOR="#008080" SIZE=1 FACE="Tahoma">Ph: +61 8 9734 8269</FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT COLOR="#008080" SIZE=1 FACE="Tahoma">FAX: +61 8 9734 8250</FONT></B></SPAN>
<BR><SPAN LANG="en-us"><B></B></SPAN><A HREF="Mailto:david.powell@bbm.wapl.com.au"><SPAN LANG="en-us"><B><U></U><U><FONT COLOR="#0000FF" SIZE=1 FACE="Tahoma">Mailto:david.powell@bbm.wapl.com.au</FONT></U></B></SPAN></A><SPAN LANG="en-us"><B></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT COLOR="#008080" SIZE=1 FACE="Tahoma">WAPL Web Page</FONT> </B></SPAN><A HREF="http://www.wapl.com.au"><SPAN LANG="en-us"><B><U></U><U><FONT COLOR="#0000FF" SIZE=1 FACE="Tahoma">http://www.wapl.com.au</FONT></U></B></SPAN></A><SPAN LANG="en-us"><B></B></SPAN>
<BR><SPAN LANG="en-us"><B><FONT COLOR="#008080" SIZE=1 FACE="Tahoma">----------------------------------------------------</FONT></B></SPAN><B><SPAN LANG="en-au"></SPAN></B><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN>
<BR><SPAN LANG="en-au"><FONT FACE="Arial" SIZE=2 COLOR="#000000"> <<Powell, David (BBM).vcf>> </FONT></SPAN>
</P>
<FONT SIZE=3><BR>
<BR>
NOTICE - This message and any attached files may contain information that is confidential and/or subject of legal privilege <BR>
intended only for use by the intended recipient. If you are not the intended recipient or the person responsible for delivering <BR>
the message to the intended recipient, be advised that you have received this message in error and that any dissemination, <BR>
copying or use of this message or attachment is strictly forbidden, as is the disclosure of the information therein. <BR>
If you have received this message in error please notify the sender immediately and delete the message<BR>
Worsley Alumina Pty Ltd ABN 58 008 905 155 is the manager of the Worsley Joint Venture - Bauxite/Alumina Operation.<BR>
Liability and responsibility of the Joint Venturers is several in accordance with the following schedule of participating interests:<BR>
Billiton Aluminium (RAA) Pty Ltd 56 percent, Billiton Aluminium (Worsley) Pty Ltd 30 percent, <BR>
Kobe Alumina Associates (Australia) Pty Limited 10 percent, Nissho Iwai Alumina Pty Limited 4 percent.<BR>
</FONT>
</BODY>
</HTML>