Moving active cell

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

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
 
Try: Cells(ActiveCell.Row, 1).Activate

--
If I've mis-understood the question please tell me.

HTH

ijb

Remove nospam from my e-mail address to talk direct

Not MCSD, MVP, TLA, P&P, PCMCIA, etc just trying to help
 
Back
Top