How to select 'found range' and the row above it (selecting two rows)

Hi there

I have the following code to find and copy a row if it meets the "What" criteria, however I would like to copy the row directing above the 'found' range as well.
Any help would be greatly appreciated.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Looks wrong to me

If it is a variable, what is the name of the variable?

May be

Please Login or Register  to view this content.

Thanks for the quick Reply!

I have no variables declared in this code. (is it recommended to declare these?)

My code works on the 'found' range; I recorded a 'Find' in the worksheet, then altered the code to loop it.

If you have an idea of a simpler code to use which searches a Worksheet for the phrase "Teacher is principal" then moves that row and and row above to a different worksheet, please let me know.

Cheers
Dan

This code copies the entire row plus the row above.

Please Login or Register  to view this content.

Thank you very much !

The code worked perfectly!!

Cheers
Dan