View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Unable to sort when column is included in range

Trudy

The blue-lined column is a "List" from DataListCreate List

To change it back to a regular column...................

DataListConvert to Range


Gord Dibben MS Excel MVP

On Mon, 7 Jul 2008 17:32:01 -0700, Trudy
wrote:

We have a spreadsheet that when a specific column is included in a selected
range, the sorting tools are disabled. The problem column can be sorted by
itself and the surrounding columns can be sorted when it is not included in
the selection. The problem column also is surrounded by a blue border that
can be resized like a drawn object.

Thanks for your help.