move one cell down

  • Thread starter Thread starter H. Nissen
  • Start date Start date
H

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.
 
ActiveCell(2).Select

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

HTH,
Bernie
MS Excel MVP
 
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
 
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:
 
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:
 
As Bernie mentioned you dont need to select to copy. You can copy without
selecting the cell

ActiveCell.Offset(1, 0).Copy
 
Back
Top