Have you tried recording a macro to see what gets recorded? There is some middle ground between your code and the code that is recorded where you will discover the missing lines that are necessary.

The Find function is sticky which means it remembers earlier find options and it can be good to reset these to ensure then don't get in the way of your code.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia