Hi Bruce

The general rule for safety is to highlight your entire block of data before
sorting. Otherwise, Excel tries to work out the extent of your data block
for you - not always in the way you intended, as you have found to your
cost.

HTH

GB




"BruceJ" wrote in message
. net...
I am leary of sorting as I have had my data "corrupted" becuase I
apparently
had some heading columns with out names.
How can I sort data (or present it in a given order-sort might not be the
best working). I use user forms and I would need to move between records
with the userforms. I know I will probably need to reprogram my
"next/previous buttons, but how can I ensure my data does not get
corrupted,
and present my data in a specified order?

Is sorting safe? What do I need to know in order to do it safely?

I am not sure if this is the "best" formum for this question in it's
entirerty, but some would be appropiate here and I know you guys know
Excel
better than the general forums.


Thanks,
Bruce