Behavior of active cell during macro recording and macro execution are different especially when I use End(xlup etc.).
Active cell wont move when manually select a range using control-shift-xlup or other cursor keys. For example when we select a range from down-right corner to the top-left corner using control-shift-xlup and control-shift-xlleft, active cell is still at the down-right corner. While active cell seems to move to the top-left corner when we execute the same key sequences during a macro.
Thus it is difficult to reproduce the same behavior by using "Record macro".