contiguous reference

J

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
 
G

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
 
J

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
 
J

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
 
G

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
 
Top