Hi

I've been having trouble with the end(xlToLeft). I've
tested it myself using ctrl+ left arrow and it should
select the cell in column A. Sometimes though, it falls a
couple of cells short when the code is run. The
destination cell is linked, but I don't see how that could
affect it.

Anyhow supposing I start off in cell E9 and want to get to
cell A9.
E9 is a variable so we'll call it MystartCell
and A9 can be MyendCell

is there any way of replacing the E part of the
MystartCell address with the A part of MyendCell address??