The point of assignments is that you do them yourself so you can LEARN. Whilst your ingenuity is admirable it circumvents the point of the assignment.

Make a real attempt and see what you can come up with that makes use of Range.MoveEnd

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia