How to set the enter key to move every 2 rows instead of one row

P

PhyllisTheCat

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

Thanks.
 
B

Bernie Deitrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting rows. 3
Multiple lines of type in one row? 3
Excel Help to copy information from one row at a time to another sheet 1
Is there a way to change the color 3
auto populate unused rows from workbook to workbook 1
How to Functionally move one cell to another 1
How to find and replace with blanks or actually delete row 1
Automatically moving from one cell to another 3

Top