Macro VBA find last instance of a word

[lindylou2]

Hi

I have a spreadsheet which I am trying to put in a macro to add a new page (below the current page in the same worksheet) so that users who are unfamilair with Excel can simply do this. I have got the macro to copy the cells I want and can get it to paste but the issue is I don't always want it to paste in the same place. The current document is 1 page long but it may need to be up to 10 pages long. I am trying to get it to find the last instance of the word "COMMENTS" and then paste the copied info 3 rows below that.

I am a complete novice at VBA but have come up with the following code so far:

Sub addnewpage()
'
' addnewpage Macro

    Range("A14:N70").Select
    Selection.Copy
    Do Until Cells(x, 1).Value Like "COMMENTS"
    Loop
    Cell(x, 3)
      
    ActiveSheet.Paste
End Sub

Although I know this is not right and needs more in it. I can't figure out how to tell it to find the last COMMENTS and how to paste 3 rows down from that.

Any help appreciated - thanks!!