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!