Hi All.
We use a simple Excel file to store job numbers, orders, etc. The sheet is locked but has some simple VBA in it to allow users to modify the content. Add row, delete row, edit row, sort rows, etc.
The sort code has recently stopped working for any cells below row 5260. The Sort code sorts a range 15 columns wide by X rows. The number of rows grows as users add new jobs.
So the range is currently 15 columns x 5269 rows. It still sorts the range but not those rows below ~5260.
Any information on this would be greatly appreciated.
Cheers,
Mark.
BTW We all run Office 2016 through Office 365 but the sheet is 10+ years old as is the VBA code within.
We use a simple Excel file to store job numbers, orders, etc. The sheet is locked but has some simple VBA in it to allow users to modify the content. Add row, delete row, edit row, sort rows, etc.
The sort code has recently stopped working for any cells below row 5260. The Sort code sorts a range 15 columns wide by X rows. The number of rows grows as users add new jobs.
So the range is currently 15 columns x 5269 rows. It still sorts the range but not those rows below ~5260.
Any information on this would be greatly appreciated.
Cheers,
Mark.
BTW We all run Office 2016 through Office 365 but the sheet is 10+ years old as is the VBA code within.