Thread: Excel 2007 - Macro (VB) code for arrow down & arrow up
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ed Ferrero[_3_] Ed Ferrero[_3_] is offline
external usenet poster
  
Posts: 108
Default Excel 2007 - Macro (VB) code for arrow down & arrow up
Hi Grindy,

To go up one cell...

Sub OneUp()
If ActiveCell.Row 1 Then
ActiveCell.Offset(-1, 0).Select
End If
End Sub

Going down use...

ActiveCell.Offset(1, 0).Select

Ed Ferrero
www.edferrero.com
Reply With QuoteReply With Quote