So have I, although I call mine __MaxValue, and it loads on open of workbook
(although I admit to rarely using it as it doesn't handle text in tests).

Bob

"JE McGimpsey" wrote in message
...
Because it looks so blasted ungainly, I've got it the value defined as
_MAXDOUBLE in my workbook template so I don't have to look at it.

In article ,
"Bob Phillips" wrote:

Because 9.99999999999999E+307 is the largest value you can get in a
cell, so
if you look it up, you get the closest match, which for LOOKUP is the
last.