LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set a rule for moving one cell down + one left in Excel? Neuroner New Users to Excel 4 November 6th 09 06:57 PM
Moving one cell with macros Alberto Ast[_2_] Excel Worksheet Functions 4 September 9th 09 06:50 AM
Moving left of a cell reference jagbabbra Excel Worksheet Functions 1 June 13th 06 02:11 PM
Moving left of a cell reference jagbabbra Excel Worksheet Functions 0 June 13th 06 02:01 PM
Moving the Active cell to the left of the screen Dave Bash Excel Programming 1 December 17th 03 04:11 PM


All times are GMT +1. The time now is 06:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"