Alex Piotto
Board Regular
- Joined
- Jul 5, 2016
- Messages
- 82
- Office Version
- 2007
- Platform
- Windows
Ciao brava gente!
I am experiencing a very strange behavior sorting a few columns of data, by date. Real dates, not text.
The script below from the macro recorder seems ok to me.
The sorting happen, but after several new insertion of rows and data, sorted every time, I get this
full of levels. Tens of them! After saving the file and reopening I get this message:
Never seen before... what is happening?
I am experiencing a very strange behavior sorting a few columns of data, by date. Real dates, not text.
The script below from the macro recorder seems ok to me.
VBA Code:
ActiveWorkbook.Worksheets("HOME").Sort.SortFields.Add Key:=Range("B13"), _
SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("HOME").Sort
.SetRange Range("B13:J10000")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
full of levels. Tens of them! After saving the file and reopening I get this message:
Never seen before... what is happening?