Domenic,

Yeah. I often find it handy to start at the bottom, and drag up. That way,
I don't have to worry about going too much farther than I wanted to, since
it stops when I crash into the top. Lazy people have lots of tricks. Then
I can back down to the top cell of my desired selection before I let go of
Mr. Mouse. In this case, B2 wouldn't be active, though one press of Enter
fixes that.

--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

"Domenic" <[email protected]> wrote in message
news:[email protected]...
> In article <#[email protected]>,
> "Earl Kiosterud" <[email protected]> wrote:
>
>> To add to Domenic's reply, it's important that the active (white) cell of
>> the B2:B100 selection be B2 to use his formula. It probably would be,
>> but
>> it's possible it not be. I thought it's worth a mention.
>
> Thanks Earl! Good point! I assumed that B2 would be selected first,
> but I suppose there may be those who would select B100 first. I'll have
> to keep that in mind for the future.