Pasting Upwards

[LEEBOO]

Is there a way to paste data up instead of down? For instance, if I have data in col A Rows 1-5 and I copy and then move to row 15, can I paste the data so that it fills upwards from 15 to 11?

 

[ADAMC]

If i read your question correctly.....Just copy your data...Highlight column 11 to 15 and hit paste!?

 

[ADAMC]

Correction*****

If i read your question correctly.....Just copy your data...Highlight ROW** 11 to 15 and hit paste!?

 

[LEEBOO]

Well I really just want to hilight cell A15 and have it paste up from there.

 

[ADAMC]

Okay, so why not just paste from Row 11 it would paste down to row 15 anway?

Or if its always the same action of copy ROW 1 TO 5 and paste up from row 15....
Sub pasteup
Rows("1:5").Select
Selection.Copy
Rows("11:15").Select
Range("A15").Activate
ActiveSheet.Paste
End Sub