return to next line question

[Guest]

I would like to be able to use a macro to return to a specific colum of the
next line when I press a preset control key i.e. ctrl + N.

Thanks

 

[E Oveson]

Not sure if this is what you want, but you could put this into a module
(changing "Z" to your desired column)

Sub newLineCol()
col = "Z"
Range(col & (ActiveCell.Row + 1)).Select
End Sub

And assign a hotkey to it through Tools->Macro...->(select that sub )
Options

 

[Chip Pearson]

Red,

Try code like
ActiveCell(2, 1).EntireRow.Cells(1, "N").Select


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com