excel macro
 

All I want is a simple macro to move down one row and then over to the far left
If I were doing this manually it would be
[down]
[ctrl][left]
What is the code that I would put in Visual Basic for this macro. If I use
the record feature, it keeps taking me to the original cell. This used to be
so easy in the older versions.

excel macro
 

ActiveCell.Offset(1).End(xlToLeft).Select

--
Charles Chickering

"A good example is twice the value of good advice."


"iguessiamadumbass" wrote:

All I want is a simple macro to move down one row and then over to the far left
If I were doing this manually it would be
[down]
[ctrl][left]
What is the code that I would put in Visual Basic for this macro. If I use
the record feature, it keeps taking me to the original cell. This used to be
so easy in the older versions.

excel macro
 

Thanks Charles.

"Charles Chickering" wrote:

ActiveCell.Offset(1).End(xlToLeft).Select

--
Charles Chickering

"A good example is twice the value of good advice."


"iguessiamadumbass" wrote:

All I want is a simple macro to move down one row and then over to the far left
If I were doing this manually it would be
[down]
[ctrl][left]
What is the code that I would put in Visual Basic for this macro. If I use
the record feature, it keeps taking me to the original cell. This used to be
so easy in the older versions.