Results 1 to 4 of 4

what is input range must be contiguous reference

This is a discussion on what is input range must be contiguous reference within the Excel Questions forums, part of the Question Forums category; Never seen this before and not sure what I am doing wrong. I cannot find a reference to contiguous reference ...

  1. #1
    New Member
    Join Date
    Jul 2002
    Posts
    24

    Default

    Never seen this before and not sure what I am doing wrong. I cannot find a reference to contiguous reference in the Excel Help.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654

    Default

    Enter "contiguous" as the keyword on the Help Index tab.

    If you can't see the Index tab click on the Show tool (leftmost position) on the Help dialog's command bar.

  3. #3
    Board Regular
    Join Date
    May 2002
    Location
    CT
    Posts
    2,915

    Default

    This means that the selection must be a single cell or the selection must be a rectangular area, not multiple unconnected areas.

  4. #4
    New Member
    Join Date
    Jul 2010
    Posts
    1

    Thumbs up Re: what is input range must be contiguous reference

    I had the same problem trying to generate a Histogram. The solution I found to work was to copy the bin data onto the same worksheet as the sample data.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com