How to set the enter key to move every 2 rows instead of one row
Would appreciate if someone can help. I want to have the cursor skip one row
after hitting the enter key. Thanks. |
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. |
All times are GMT +1. The time now is 01:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com