View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default How to set the enter key to move every 2 rows instead of one row

Phyllis,

Try this event code. Copy the code, right-click the sheet tab, select "View Code" and paste the
code into the window that appears.

Private Sub Worksheet_Change(ByVal Target As Range)
Target(3).Select
End Sub

I've assumed that when you are 'hitting the enter key' you are entering a value into a cell.

HTH,
Bernie
MS Excel MVP


"PhyllisTheCat" wrote in message
...
Would appreciate if someone can help. I want to have the cursor skip one row
after hitting the enter key.

Thanks.