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!
|