This happens a lot if there is a column in the sort area that
references another row and the row does not exist after the sort is
completed. For example, if one column contains an accumulating
amount, like a value in that row plus the total form the row above.
After the sort the new top row will reference the row above it, but if
that is the top row of the worksheet a row above will not exist and
you will get that error in the top row, and it will propogate
throughout. You could make the make the formulas a little more
robust, or you can recreate them after the sort.

Good luck.

Ken
Norfolk, Va


On Oct 4, 1:17 pm, dan dungan wrote:
How did you try? Manually or with VBA?

It sounds as though the numbers in your column are results of a
formula.

On Oct 4, 9:43 am, wardle86
wrote:



I try and do it but the cells then just cpme up with #ref! in them, why is it
doing this?- Hide quoted text -

- Show quoted text -