it would be very nice if Excel could do this without any macro

Interesting reflection this one! I guess Microsoft's object is to
provide, in all cases, a "basic" tool but flexibile enough to be
modified, adapted, remodeled by the user via VBA. Which is why it is
invaluable to know one's way around VBA to some degree.


David


--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=478912