Selecting 1 column left from active Cell

  • Thread starter Thread starter rob nobel
  • Start date Start date
R

rob nobel

I know this should be so simple, but what would be the code to backstep 1
column from the active cell?
Rob
 
Hi Rob!

Try:

ActiveCell.Offset(0, -1).Select

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
rob,

I think that was one of the first questions that I asked here.
Tried recording it in a macro, searched everywhere in Help
for move, up down, go, shift, back, you name it. Everything
except offset.

John
 
Yes John, I tried various ways too, but MS doesn't want to help too much
with the offset method.
HOWEVER......
Just discovered a way to get the recorder to use offset. Well for this
purpose anyway.
If you start recording a new macro, there's a Relative reference button on
the stop recording toolbar which, if depressed gives the following result.
ActiveCell.Offset(0, -1).Range("A1").Select
How cool is that!! But I guess you already know that.
Rob
 
Back
Top