Moving down two rows when Enter is pressed

P

Paul Layland

Hi there.

On a particular sheet, I want the cursor to move down *two* rows when I
press Enter rather than the usual one. Is there a neat way of doing
this?

Many thanks in advance for your help.
 
D

Don Guillett

How about without even pressing enter. right click sheet tab>view
code>copy\paste this>save.
Now when you enter something in ANY cell you will go down 2 rows from that
cell. You would probably want to restrict it to a certain column by
uncommenting the 1st line

Private Sub Worksheet_Change(ByVal Target As Range)
'if target.column<>2 then exit sub
Target.Offset(2).Select
End Sub

--
Don Guillett
SalesAid Software
(e-mail address removed)
"Paul Layland" <[email protected]>
wrote in message
news:p[email protected]...
 
P

Paul Layland

Brilliant- just what I needed. (And I didn't even need to ask abou
restricting it to one column!). Many thanks Don
 

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

Macro for moving rows 3
moving rows to another sheet 3
Pressing Enter to skip rows 4
Pressing Enter to skip rows 1
Commands for cursor moving right, left, up, down. 4
Excel2007 Stipulate where cursor goes when Enter Key pressed 5
Dymanic List Range 2
Macro to compare rows in 2 files where ID is the same 0

Top