Excel Macro to start cursor at a specific field
Posted on 2011-05-10
I am using the following code to tab from F to G. Then it goes down to F then G again and so on and so on. I am just entering data into the F and G field. What i need is when open the cursor automatically starts at F6. Here is my code. Can I add anything to start at F6?
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Column > 7 Then
Application.EnableEvents = False
Target.Offset(1, -Target.Column + 6).Select
Application.EnableEvents = True