View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
H. Nissen[_2_] H. Nissen[_2_] is offline
external usenet poster
 
Posts: 27
Default 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.


.