LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
flaterp
 
Posts: n/a
Default List vector using upper and lower limits

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CHANGE LOWER TO UPPER CASE IN EXCEL FOR WHOLE SPRDSHT Impossible One Excel Worksheet Functions 1 May 13th 05 09:33 PM
How do I convert all upper case excel sheet into upper and lower . DebDay Excel Discussion (Misc queries) 1 March 9th 05 08:31 PM
Upper & Lower case problem in VBA Rob Excel Discussion (Misc queries) 2 February 10th 05 07:46 AM
How do I easily draw in Excel the Upper and Lower limits of a con. Judy Charts and Charting in Excel 3 January 12th 05 09:21 AM
changing lower case to upper case T. Campbell Excel Discussion (Misc queries) 1 December 8th 04 05:37 PM


All times are GMT +1. The time now is 09:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"