start from bottom, find first instance of "Page", paste copied range below it...possible?

Hello all. I am working on creating a template. that being said, i am probably going about it the wrong way :-). but anyways, i am trying to figure out a macro to start from the bottom, say row 65535, just cause that is waaaay below any data that will ever be on the sheet, and search up to find the first instance of the word "Page" in column A. Before that, i have code that will copy a certain preset range. i will then need to paste that copied data on the clipboard to the cell directly below the first instance of "Page" found. It sounds like a pain but i'm sure someone out there has something!! =)

thanks!

This will find the first instance of "Page" in Column A searching up from the last row with data. I'd have to see the other code you have already to incorporate that as well.

Please Login or Register  to view this content.

Hi John! thanks for the code snippet!!! i was able to play with it a bit and finally got done what i needed to. used this:

Please Login or Register  to view this content.

thanks again!

You're welcome. Glad to help out and thanks for the feedback.