Finding highest number in a range of cells

Hi,

I am working with a "register" in excel. What VBA code should I use to find the highest number in a range of cells (not sorted in particular order)? All numbers are integers.

I would like to know the actual number in that cell, the cell reference and the row number.


Thx,


Marcus

Thx Roy,

this helped perfectly fine.

Marcus

Originally Posted by royUK

Like this

Please Login or Register  to view this content.