hi folks.

when I am using histogram in data analysis tools, I have my input
range and bin range in 2 sheets, but there always popup "Input range
must be a contiguous refrence". This happens since last week. but
it never happened before.

I don't know what setting was changed, and I didn't set "R1C1 reference
style" .
in option.


Please help! many 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