Hi,
I have the code below which looks for a min valve in a range which is working ok. The range of columns and rows does vary which I have sorted in the code.
At the moment the lowest value is highlighted on the sheet (data) and a Msgbox will report its location, i.e. $AA:$2000 or $BZ:$1000...