a funny problem
 

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

a funny problem
 

As usual, post YOUR code for comments.

--
Don Guillett
SalesAid Software

"Libby" wrote in message
...
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??

a funny problem
 

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

--
Message posted from http://www.ExcelForum.com