Thanks Gord!

but my input range consists of only one range.

I selected my input range, say, sheet1!$B$2:$B$B51, and the bin range
and output range, and click OK, then the contiguous warning window
popup. The input range always displayed as something like
[myexcel]sheet1!R1C2:R50C2.

thanks!
jeff


--
jjeff
------------------------------------------------------------------------
jjeff's Profile: http://www.excelforum.com/member.php...o&userid=12039
View this thread: http://www.excelforum.com/showthread...hreadid=570237