View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Albert Einstein Albert Einstein is offline
external usenet poster
 
Posts: 3
Default Move contents of selected cell down one, and to the left one cell?

I am looking for a way in a macro to do the following:
1. I select a single cell (this example C3)
2. The contents of that cell are cut
3. I then want to move the data down one and to the left ( this
example B4)
4. Then paste the contents in memory to the new cell.

Also, I would like to make this macro available for any spreedsheet.
What would be the best way to set it up? I am using Excel 2003.
Thanks in advance,
Mark