move one cell down
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:
ActiveCell(2).Select
but there is rarely ever any need to select a cell.
HTH,
Bernie
MS Excel MVP
"H. Nissen" wrote in message
...
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.
.
|