Thread: Excel VBA Help
View Single Post
  #2  
Old 08-17-2007, 07:27 AM
kerowo kerowo is offline
Senior Member
 
Join Date: Nov 2005
Posts: 6,880
Default Re: Excel VBA Help

If you want all the other cells to move as well:
Record a macro
select a cell
insert a cell above it moving it down
insert a cell to the right of it moving the cells to the left
stop the macro

If you want to cut and paste overwriting the contents of the target but not moving other cells:
Record a macro
select a cell
cut
paste in target
stop the macro

You may have to edit the last macro to generalize the target cell from source cell, but it should just be a matter of taking the active cell and adding one to the row and column.
Reply With Quote