Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using VB to unhide hidden rows based on user response
I have 10 rows in groupings of 2 (total of 5 groupings) that are
hidden. Based on user input in a cell I want to unhide the rows. The user will input a number from 1 to 5 in cell A15. Each number is to unhide 2 rows progressively. (Currently 20/21, 22/23, 24/25, 26/27, 28/29) Example: User input of 1 will unhide 20 and 21. An input of 2 will unhide 20, 21, 22, and 23. An input of 3 will unhide 6 rows. Etc. Can VB do this? (If so where can I find the code or can you write it here.) Can it be automatic anytime that cell is changed or will I need to create a button to run the specified macro code. (The automatic is better but will take what I can get.) Any help you can offer would be apprecaited. Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hidden rows unhide by themselves | Excel Discussion (Misc queries) | |||
hidden rows unhide on their own | Excel Discussion (Misc queries) | |||
unhide row does not unhide the hidden rows | Excel Worksheet Functions | |||
macro that brings user to cell based on "yes/no" response | Excel Discussion (Misc queries) | |||
Why cannot I unhide the hidden rows ? | Excel Discussion (Misc queries) |