try:

=MAX(A1:A100)

Regards,
KL


"pjs83" wrote in message
...
How do I return the highest value in a range of cells