List vector using upper and lower limits

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I am trying to reduce a column of data from ~8200 rows to ~1200 rows. I have
2 spin buttons that control the upper and lower limit the user desires. Is
there a way to reference just the cells within the range?

For instance . . . data is listed from A1 to A8200. A new list is generated
from the upper and lower limits depending on their respective spin button
value (ie. a lower limit value of 2481 would be the beginning point of the
'new' data range and an upper value of 3674 would be the end). The reduced
list (from A2481 to A3674) is then written in column 'B' and dyamically
changes with the spin buttons.

I appologize if this is too vague and thanks in advance.
.

Relevant Pages

  • Re: Programmable Counter
    ... and lower limit, which can be programmed when enable is low. ... upper limit and lower limit? ... limit which is only enabled at the appropriate time when not counting. ...
    (comp.lang.verilog)
  • Re: What if there was no dark matter?
    ...   Bound on the dark matter density in the Solar System ... to see except with really specialized instruments. ... According to the abstract, which is all I could read, this is an upper ... They didn't give a lower limit. ...
    (talk.origins)
  • Re: Creating 2D graphic strip chart with trace wrapping
    ... The dynamic range of some of the data traces is quite large, ... "shoots through" the upper limit, it re-enters from the lower limit. ... somehow possible to reflect the 2D line at the upper and lower bounds, ...
    (comp.graphics.api.opengl)
  • Re: Using CountIf with criteria on another sheet
    ... perfect match. ... >> fall between upper and lower limit values on another sheet? ... >> Where a1:z1 are values to be compared against the upper and lower limit ... >> then counted if they meet the criteria ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Best Ebay listing ever
    ... plastic tube or something. ... finger puppet looking things that spin around in the upper right corner ...
    (rec.games.pinball)