macro

  • Thread starter Thread starter louise.philip
  • Start date Start date
L

louise.philip

Dear all
I am trying to create a macro that will move the contents
of a cell to two cells below. I have created a macro
that will move the cell, however, how can I edit the
macro in vb that will tell it automatically move it two
cells beneath?

the worksheet has approximately 2000 cells to move, hence
the macro would be quicker.

Any quick responses would be much appreciated.

Thank you.
Louise
 
Louise,

Could use a little more information if you want some more specific help.

Try using the Offset function.

Activecell.Offset(2,0).Select

Post back with what code you have and what you're trying to do.

John
 
Back
Top