View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mustafa S N Mustafa S N is offline
external usenet poster
 
Posts: 4
Default Moving Cell up, down, left or right thru Macros

Hi,

I Want to use copy paste from one sheet to another thru Macro and when I use
the Macro it should copy after the end portion of the previous paste. The
cell should move down two places and then the home key to go to the A column
and then paste the text again. Everytime it should check the last row and
column where the text is and then go three rows down and then to A column. I
can use CRTL+END key thru Macro to go to the last used Cell, but do not know
the command to move the cell down three and then to A column.

Pls. suggest at the earliest.

Thanks in Advance.

Mustafa