"Contiguous" means touching or beside.

It would seem your input range consists of two or more discrete ranges.

Change that configuation to prevent the error message.


Gord Dibben MS Excel MVP

On Thu, 10 Aug 2006 02:19:07 -0400, jjeff
wrote:


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