what is input range must be contiguous reference

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: what is input range must be contiguous reference

  1. #1
    New Member
    Join Date
    Jul 2002
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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.

User Tag List

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