Does anyone know if there is a (significant) price to pay in terms of speed
or memory usage if when using a vlookup you select the whole sheet as the
array (=VLOOKUP(MAX(A:A),1:65536,2))
instead of a defined array (such as A1: G500). It is one more chore to have
to define the target array and I am just wondering if it is worth it?

ANy feedback much appreciated.

Kind regards, Mark