Excel 2007 records the sort operation differently than Excel 2003. In 2007, the range is specified in the SetRange method while in 2003 the Selection object is used. Take this simple checkbook workbook. If you record a macro to sort on check number in 2003, you get something like this
Sub Macro3()
'
' Macro3 Macro
' Macro [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2011/02/21/recording-a-sort-macro-in-2003-vs-2007/
Posted
Feb 21 2011, 06:30 AM
by
Daily Dose of Excel