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" wrote in message
...
In article ,
"Earl Kiosterud" 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. :)