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

"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

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!


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

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

Cannot replicate your problem with a contiguous range.

I have tried with filters on, rows hidden and blank rows hidden but cannot get
the error message if range is contiguous.

The [myexcel]sheet1!R1C2:R50C2 looks like you are referencing sheet1 in myexcel
workbook.

The R1C1 notation can be turned off at ToolsOptionsGeneral if you wish.


Gord


On Thu, 10 Aug 2006 15:35:00 -0400, jjeff
wrote:


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!