Hello guys, I need some help on this issue:
I exported a few tabs in multiple excel sheets, I colored cells and everything but I can't get the sorting function to work. I got the command from VBA macro and the qlikview macro doesn't like it at all!!!
It doesn't even try to run
I'm using these two lines:
objCurrentSheet.Sort.SortFields.Clear
objCurrentSheet.Range("AA:EE").Sort Key:=objCurrentSheet.Columns("A"), Order:=xlDescending
The first one works perfectly, the secon one is not accepted.
Thank you for any suggestion!
Best Regards
Michele