move one cell down

[H. Nissen]

Hi, I need to make a macro who can move one cell down from the active cell
and make this cell active. ex: active cell = C1 => new active cell C2.

I hope some of your hard guys can help me with this problem.

 

[Bernie Deitrick]

ActiveCell(2).Select

but there is rarely ever any need to select a cell.

HTH,
Bernie
MS Excel MVP

 

[FSt1]

hi
from you example, i'm having a problem understanding what your are trying to
do.
but..
Activecell.offset(1,0).select

not sure if this helped. post back with more info on what your are doing.

regards
FSt1

 

[H. Nissen]

Hi, This form works, thx: '
ActiveCell.Offset(1, 0).Select
Selection.Copy

I have to use it, to copy values from a excell sheet into an other
application. With this macro, I do not have to mark and copy every 1240 cpr's
manually

But thx for the help to make this macro.

"Bernie Deitrick" skrev:

 

[H. Nissen]

Hi, This form works, thx: '
ActiveCell.Offset(1, 0).Select
Selection.Copy

I have to use it to copy values from a excell sheet into another
application. With this macro, I do not have to mark and copy every 1.240
cpr's manually

But thx for the help to make the macro.

Mvh Hans

"Bernie Deitrick" skrev:

 

[Jacob Skaria]

As Bernie mentioned you dont need to select to copy. You can copy without
selecting the cell

ActiveCell.Offset(1, 0).Copy