Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Dynamic Ranges (2003)

    I have a workbook that allows the user to select from a drop down and then charts the result. This is a monthly file, meaning that every month I have to change the various ranges.
    I am trying to use dynamic ranges and am failing! Attached is a stripped down version that uses dynamic ranges for the database and the criteria but leaves the range names for extract static.

    I cannot see the forrest for the trees at this point. What am I doing wrong?

    Any help is appreciated.

    itconc
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Dynamic Ranges (2003)

    Can you explain how you would want the extract range to be dynamic?

    BTW, your criteria range name is invalid, it uses OFFFSET instead of OFFSET.

  3. #3
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Dynamic Ranges (2003)

    Thanks, Hans. I have fixed the offfset typo but it still does not work.
    I want the extract range to work like the database and the criteria range. Potentially using 13 columns. BTW, the macro attached to the button should be FilterPU and not FilterPUOld.
    Thanks,
    itconc

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Dynamic Ranges (2003)

    There are several problems with the workbook and the defined names.
    - The name of the first sheet is <code>' Chart Data'</code> with a space before Chart.
    - You have hidden data in rows 66 - 83.
    - You have data in row 86.

    Try cleaning up the workbook before continuing.

  5. #5
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Dynamic Ranges (2003)

    I have decided that the only way to handle this issue is to use a dynamic range for the database, a static one for the criteria and use vba to create the extract range and the range for the chart. That has worked like a charm.

    Thanks for all your help!

    itconc

Posting Permissions

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