Macro from moving from column 12 to the next row of column 5 not working

**catchnanan** · 08-05-2013, 05:39 PM

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 17 Then
Range("E" & Target.offset(1,0).Row).Select
End If
End Sub

Dear Friends

I have one simple task like when i move from column E to column q and press enter it
should go to the next row Eth column i wrote the macro but it is not working
plz help me to correct the macro

**GC Excel** · 08-05-2013, 05:44 PM

Your macro will work only if you change the value of the cell in column Q.

**TMS** · 08-05-2013, 05:46 PM

Works for me. Have you got Macros enabled? Is the code in the Worksheet Class module for the worksheet where you are making changes?

Just pressing Enter in column Q won't work as it won't be seen by Excel as a change to the cell. You can press F2 and Enter or you would need to type in the cell.

Regards, TMS

**catchnanan** · 08-05-2013, 05:58 PM

My Dear friends

Thank u so much for your quick response
Now only i have started to learn vb codes and it is my very first macro attempt.i am good at using formulas.
But only codes seem to give a better and greater control and provide a lot of options
How can i learn codes can you please kindly help me i want to learn vb codes
I am not into software side I am working in a bank only i am very curious about learning excel codes

Nana