I am trying to move the active cell to the column A in the
same row. I am using the following code.

ActiveCell.End(xlToLeft).Activate

The problem is it stops at a cell if there is a formula in
it. It works fine if the row is empty.

Thanks