macro

[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

 

[John Wilson]

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