![]() Sheets("Value of Incentives by Cust").Select To set a filter, sort on a column and then clear the filter, the following code (with comments) can be used. For Excel 97-2003 simple sorting cannot be cleared as the data order is simply changed and the method is not stored in memory.Ī filter can however be both set and cleared. ( 3/5 from 1 vote) The sorting functionality is more advanced in Excel 20 than Excel 2003 and prior. "E8:E9"), CopyToRange:=Range("Targeted"), Unique:=False ![]() Range("B18:I80").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _ With ActiveWorkbook.Worksheets("Value of Incentives by Cust").Sort Key:=Range("U19:U80"), SortOn:=xlSortOnValues, Order:=xlDescending, _ ![]() Any ideas? PLEASE help.ĪctiveWorkbook.Worksheets("Value of Incentives by Cust").ĪctiveWorkbook.Worksheets("Value of Incentives by Cust"). _ However, my colleague sees a runtime 438 error when she tries to run it in Excel 2003. ( 3/5 from 1 vote) I am running these two macros in my spreadsheet in Excel 2007 and they run perfectly.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |