Macro VBA find last instance of a word

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:

Please Login or Register  to view this content.

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!!

Hello lindylou2,

Welcome to the Forum!

It would nice if you shared the solution with your fellow members or at least provided a link to the site where it was solved.