View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
stacy[_2_] stacy[_2_] is offline
external usenet poster
 
Posts: 30
Default Auto Sort Columns on Workbook Open

Nope... You hit it right on the mark!! I have people in this thing
that shouldn't be, and they have entered numbers as text, numbers as
numbers, and numbers as God knows what!! So when I do a simple "select
column 'B', and sort", it prompts me that some numbers are text, etc,
and how do I want to treat them. I then tell it to treat anything at
all that resembles a number, as a number, and sort it... Works fine.
Your solution aboves is just what I needed!!! Works great!! Needless
to say I am going to have few words with a select group of users making
my world harder than it should be!! :))

Thanks again Dave!!! Perfect solution!