MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Moving down a cell??


Posted by Eck on January 18, 2002 6:58 AM

Im trying to make a macro where the selected cell will copy, and then move down a row and paste. The first part of the formula works fine, and i can get a copy out of it wherever i select, but the last part is where im stuck. There is the exact cell location that was pasted, and every time i run the macro, it returns to that same spot to paste. what do i put in the "Range"? Is there like a MOvedown command or somthin??


Posted by Joe Was on January 18, 2002 7:18 AM

Try this code!

Sub myMCopy()
'Copy current selection.
'Offset is (ROW, COLUMN)
'Away from selection is a +cell count.
'To A1 from the selection is -cell count.

Selection.Copy
ActiveCell.Offset(1, -1).Select
ActiveSheet.Paste
ActiveCell.Offset(0, 1).Select
End Sub