ExcelBanter - sorting a sheet with outlined rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sorting a sheet with outlined rows (https://www.excelbanter.com/excel-discussion-misc-queries/92863-sorting-sheet-outlined-rows.html)

Ron

sorting a sheet with outlined rows

I have a large sheet with about 1000 rows that are outlined/hidden. I am
trying to sort a thousand rows that are above this range, but when I do, the
wrong rows are sorted. I discovered, after much agita, that when I remove the
outlined rows, the data sorts properly. Known bug?
--
Ron

All times are GMT +1. The time now is 10:33 PM.