topic EXCEL SORTING COLUMNS.... HOW???!! in QlikView https://community.qlik.com/t5/QlikView/EXCEL-SORTING-COLUMNS-HOW/m-p/417889#M155428 <HTML><HEAD></HEAD><BODY><P>Hello guys, I need some help on this issue:</P><P>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!!!</P><P></P><P>It doesn't even try to run <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P><P></P><P>I'm using these two lines:</P><P>objCurrentSheet.Sort.SortFields.Clear</P><P>objCurrentSheet.Range("AA:EE").Sort Key:=objCurrentSheet.Columns("A"), Order:=xlDescending</P><P></P><P>The first one works perfectly, the secon one is not accepted.</P><P></P><P>Thank you for any suggestion!</P><P></P><P>Best Regards</P><P>Michele</P></BODY></HTML> Sun, 13 Jan 2013 11:12:20 GMT 2013-01-13T11:12:20Z EXCEL SORTING COLUMNS.... HOW???!! https://community.qlik.com/t5/QlikView/EXCEL-SORTING-COLUMNS-HOW/m-p/417889#M155428 <HTML><HEAD></HEAD><BODY><P>Hello guys, I need some help on this issue:</P><P>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!!!</P><P></P><P>It doesn't even try to run <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P><P></P><P>I'm using these two lines:</P><P>objCurrentSheet.Sort.SortFields.Clear</P><P>objCurrentSheet.Range("AA:EE").Sort Key:=objCurrentSheet.Columns("A"), Order:=xlDescending</P><P></P><P>The first one works perfectly, the secon one is not accepted.</P><P></P><P>Thank you for any suggestion!</P><P></P><P>Best Regards</P><P>Michele</P></BODY></HTML> Sun, 13 Jan 2013 11:12:20 GMT https://community.qlik.com/t5/QlikView/EXCEL-SORTING-COLUMNS-HOW/m-p/417889#M155428 2013-01-13T11:12:20Z