need help with macro -move cursor down then home
 

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

Correction need help with macro -move cursor down then home
 

correction that should read
ActiveCell.Offset(1, -3).Select

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

need help with macro -move cursor down then home
 

Try

activecell.End(xlToLeft).Offset(1,1).Select

GB



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

need help with macro -move cursor down then home
 

thanks GB
fo replying
I will try this now

Peter
"GB" wrote in message
...
Try

activecell.End(xlToLeft).Offset(1,1).Select

GB



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

need help with macro -move cursor down then home
 

Good as Gold
Thanks that worked!!



"GB" wrote in message
...
Try

activecell.End(xlToLeft).Offset(1,1).Select

GB



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

need help with macro -move cursor down then home
 

More reliable might be:

Cells(ActiveCell.Row+1,2).Select

Doesn't depend on values being in other cells.

--
Regards,
Tom Ogilvy

"Ftca" wrote in message
...
Good as Gold
Thanks that worked!!



"GB" wrote in message
...
Try

activecell.End(xlToLeft).Offset(1,1).Select

GB



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