Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
ok, before i start working on my excel sheet,
I'd like to specify in some how in some way, (pop up window, or entering a number in a cell, it doesnt matter as long as its "excel-newby-friendly") A range of rows i wont be using, and have it hide those rows. (or, preferrably, i'd like to specify which rows I WILL be using, and have the script auto-hide the rest.) In Column A, the cell values a "A-1" through "A-20" after A-20, the next cell's value is "B-1" through "B-20", and so forth, up to "O-1" through "O-20" those cell values never changed. i use them to identify the rows in my sheet. anyhow, So before i start, the question is asked: USING ROWS(to input data): A-1 through A- [x] B-1 through B- [x] C-1 through C- [x] (and so on, up to O-1 through O-[x] The [x] indicates where i'd input a number (if it can have a default number, like "2", that'd be awesome) SUBMITTING this information would have excel HIDE every row not specified within that 300 row range. So... lets say i said USING ROWS: A-1 through A-[5] B-1 through B-[10] This would make the rows with Cell's A-6 through A-20 HIDE, and rows with cells B-11 through B-20 HIDE. (Well, reastically, i'd also be specifying which of the "C- " , "D- ", etc , rows to also not hide...but i think you understand) If it can't be done this way, i'm open to any other methods of accomplishing this.. TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I hide multiple rows under one row IN EXCEL? | Excel Worksheet Functions | |||
Is there a way to conditionally hide rows in Excel? | Excel Worksheet Functions | |||
Why do my rows automatically hide in Excel? | Excel Worksheet Functions | |||
Hide And Un-hide Excel Toolbars | Excel Programming | |||
How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) |