I like to know how do you move the active cell to the extreme left side of a row when in between there are blank cells. I tried using the macro recorder to record this action but the result is not what I want. What I want is whenever I execute this macro the cursor will move to the extreme left end. Usually by pressing the "Home" key will do the trick but not in macro recording mode.