Sorting within an array
 

I have a range in my workbook that has an array formula. I'd like to sort
that range and get the comment, "You cannot change part of an array" when I
try it. Is there a way without un-doing the array, sorting and then re-doing
the array?

Sorting within an array
 

Not that I know.

Steve wrote:

I have a range in my workbook that has an array formula. I'd like to sort
that range and get the comment, "You cannot change part of an array" when I
try it. Is there a way without un-doing the array, sorting and then re-doing
the array?

--

Dave Peterson