MACRO - go UP or DOWN

  • Thread starter Thread starter DAA
  • Start date Start date
D

DAA

Please help me write the macro to move ONE cell UP or DOWN.

The following macro moves ONE cell to the RIGHT:
ActiveCell.Next.Select

The following macro moves ONE cell to the LEFT:
ActiveCell.Previous.Select

I can't figure a similar macro to move ONE cell UP or DOWN.

Thanks in advance.
 
DAA said:
Please help me write the macro to move ONE cell UP or DOWN.
Click to expand...

Activecell.Offset(1, 0).Select
Activecell.Offset(-1, 0).Select

HTH. Best wishes Harald
 
Back
Top