| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide rows with macro
I have a question about hiding and unhiding rows with a Macro. I hav searched trough the forum but I couldn't find the right solution for m specific problem. The situation is as follows: I have a sheet that I want to make a bit smaller, by hiding rows. Th amount of visible rows can be entered in cell F7. The rows that shoul be hidden are rows 14 till 25. So if the number of visible rows entered in cell F7 is 1, row 1 unhides, if it's 2 row 14&15 unhide etc. Is there a way to do this in a Macro? Many thanks in advance for your help. ps. I'm sorry for any grammar or spelling mistakes, English is not m mother language : -- Fugaz ----------------------------------------------------------------------- Fugazy's Profile: http://www.excelforum.com/member.php...fo&userid=3517 View this thread: http://www.excelforum.com/showthread.php?threadid=54947 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro code to hide rows and not calculate hidden rows | Excel Discussion (Misc queries) | |||
| Macro to hide rows | Excel Programming | |||
| hide rows with macro | Excel Programming | |||
| hide rows with macro | Excel Discussion (Misc queries) | |||
| macro to hide rows | Excel Discussion (Misc queries) | |||
![Fugazy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
