Appending to Existing Data

[jtk911]

I need to move the cursor down one row after going to the end of existing data.
Otherwise, when I paste, it would overwrite the last row of the existing data.
How do I write that in VBA.

BTW, all my VBA code is based on MrExcel forum board discussions, in other words I can't write but reading VBA makes sense.

Here is what I have so far.

'Append NY CapEx data into CY CapEx
Range("A1").Select
Selection.End(xlDown).Select
'This row still has data. I need the cursor to move one more row down before I paste.
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False

My apologies to all as I'm sure this is quite elementary.

 

[VoG]

Try

Range("A1").End(xlDown).Offset(1).PasteSpecial Paste:=xlPasteFormulas
Application.CutCopyMode = False

 

[jtk911]

Works perfectly! Thanks so much.