Have a look at Aladin's explanation in the following thread...

http://www.mrexcel.com/board2/viewtopic.php?t=105725

In article ,
Mayank wrote:

Thanks a lot Domenic it works but can you explain how does
9.999999999999999E+307 is actually looking for the last numeric value in the
column.