EXCEL SORTING COLUMNS.... HOW???!!

[#1]

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