On 10 May 2007 13:02:05 -0700, merjet wrote:

In your VB Editor "Integer)" s/b on the same line as the one before
it.
When posted here, long lines can overflow to the next line.

That corrected the problem. It didn't occur to me that VB as line
sensitive.

=MatchLast($B24, $B$2:$B23, 2)

appears to work for me. Now I need to find the macro and tell Excel
to trust it.