|First, a posting tip...|
Please click on the blue line at the end of this post and read the instructions on how to post example data in this forum. Thanks!
How about using the MAX function?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.