It's kind of strange. Columns A to H have data the user enters. Columns
I to T have the option buttons. Column U is the cell link. If I select
columns A to U and use Data|Sort, it will sort all the columns
including U except columns I to T (with option buttons). If I select
columns A to T, it will sort I to T. Of course column U is excluded on
the latter. I tried setting the cell link to a column left of the
option buttons. If I then select all columns, it will sort the columns
with the option buttons but not the column containing the cell link
value. I'm stumped.

Dave Peterson wrote:
Make sure you include all the columns that need to be sorted in the range to be
sorted.

If you're selecting one column and then using the icon on the Standard toolbar,
try selecting the whole range and use Data|Sort.

wrote:

Dave,

I was able to user your macro for my project.

Do you know of a way to sort the columns with the option buttons after
the user makes the selections? We will have a spreadsheet that a user
fills in from a list. The columns to the left of the columns with the
option buttons will be filled in by the user. The first column contains
the last name of a student. The data will be sorted by last name after
everything is entered. The columns with the option buttons are not
being sorted with the rest of the columns. Can I sort the columns with
the option buttons along with the other columns?

Thanks for any help.

--

Dave Peterson