They must be contiguous columns.
Select them all together *before* you choose <Data> <Sort>.
Never, never, never allow XL to choose your sort range for you.
Never, never, never use the sort icons on the tool bar.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
