contiguous reference

[jjeff]

hi folks.

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

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


Please help! many thanks!
jef

 

[Gord Dibben]

"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

 

[jjeff]

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 rang
and output range, and click OK, then the contiguous warning windo
popup. The input range always displayed as something like
[myexcel]sheet1!R1C2:R50C2.

thanks

 

[jjeff]

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 rang
and output range, and click OK, then the contiguous warning windo
popup. The input range always displayed as something like
[myexcel]sheet1!R1C2:R50C2.

thanks!
jef

 

[Gord Dibben]

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 Tools>Options>General if you wish.


Gord