First - thanks in advance for the help!
Using Excel 2007
Cell D3 is where I want the user to input a value between 1 and 2000. This value represents how many rows to show starting at row 6 and ending at row 2005.
Cell D3 row # to be shown
1 6
2 6-7
10 6-15
100 6-105
500 6-505
2000 6-2005
But more importantly, say cell D3 currently has 480 and rows 6-485 are showing. If the user changes cell D3 from 480 to 7, then only rows 6-12 should be shown and rows 13-2005 would now be hidden.
I need the hiding & unhiding to occur on the event of Cell D3 changing.
Please provide the VBA code as I don't know how to write VB code.
Again - thank you, thank you, thank you!!!!
Bookmarks