need help - macro to move cursor

  • Thread starter Thread starter Ftca
  • Start date Start date
F

Ftca

Hi all
can someone help me with code to
move the cursor down a row and to column 2?

I've been using
ActiveCell.Offset(0, -3).Select

but it has flaws , I need it to go to the 2nd col from left


TIA
 
I think you are attempting to go from a beginning cell to a destination cell
which is on row down and one column to the right. If that is correct, the
code would be

ActiveCell.Offset(1,1).select

Incidently, try to get away from using select in your code. It really slows
things down. For example, if beneath the above code was:

Selection.Interior.Color = vbBlue

it would be much faster to just do this:

ActiveCell.Offset(1,1).Interior.Color = vbBlue

tim
 
thanks tim
but I need the cursor to go down 1 row then left to column 2 or b
i.e 2nd column , regardless of where the cursor is in the begining

and thanks I will try and avoid select

ta
 
thanks tim
but I need the cursor to go down 1 row then left to column 2 or b
i.e 2nd column , regardless of where the cursor is in the begining

and thanks I will try and avoid select

ta

ActiveCell.Offset(1, -(ActiveCell.Column - 2)).Activate

(You can use ".select" if you must.)
Any good?

CoRrRan
 
Yes that works a treat too
Thanks
I'm so gratefull for all the suggestions I have recieved
its funny how all worked
yet none were the same :-)

I have solved this problem now

what a great thing this support group is!

Peter
 
Back
Top