a funny problem

[Libby]

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??

 

[Don Guillett]

As usual, post YOUR code for comments.

 

[pikus]

Please explain what you are doing here. I'm guessing there is an easie
way to do it, but I need more info. - Piku