MACRO - go UP or DOWN

[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.

 

[Harald Staff]

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

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

HTH. Best wishes Harald

 

[DAA]

Thanks a lot, Harald. Have a great weekend.

-----Original Message-----
"DAA" <[email protected]> skrev i melding DOWN.

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

HTH. Best wishes Harald


.