Find Last Row of Column "A" +1 row and paste 4 columns to the right

[jaguinaga]

A	B	1	2	3	4
5	6	7	8	c	b
8	7	6	A	[EMPTY]	[EMPTY]
[LAST ROW +1]	[LAST ROW +1]	[LAST ROW +1]	[LAST ROW +1]	[Paste Data]

Hello, I am trying to find the last row of a column + one additional row to paste values below. I need to be able to find the last row of column 1 and paste in column 4. The issue I run into is that the last row does not always end in the same place for each row, but the pasting of data needs to line up. Any suggestions?

Currently use this which works as long as everything ends at the same row.

'lastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row + 1
'Range("A" & lastRow).Select
'Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats

 

[dreid1011]

Where is the pasted data coming from? And will you always be looking in column A for the last row? And is the destination column 4 (which would be column D from A) or 4 columns away (which would be column E from A)?