a funny problem

  • Thread starter Thread starter Libby
  • Start date Start date
L

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??
 
Please explain what you are doing here. I'm guessing there is an easie
way to do it, but I need more info. - Piku
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need help creating a macro 2
How to turn a cell "OFF" or Null it's Contents? 3
Getting Worksheet_Change to Ignore First Row 2
? offset('activecell',,-2,1,1) in Named Formula ? 1
Multiple "IF" statements in a formula 1
Code not working 3
Summing Cells and Formatting 1
macro or formula to paste values from one tab to another 1

Back
Top