I had found that already but trying to figure out why some do and some dont.
I also found while doing some sorting that when i sort on collums and tell it
to expand selection that not everying is sorted.

It appears as if somehow excel has decided that each row is chopped into
seperate sections. Need to let it know the entire row is one record.


"D." wrote:

I know there was a reply to this already but can't see it so...

check out this site

http://www.mvps.org/dmcritchie/excel/insrtrow.htm