| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide multiple rows
I would like to unhide a few rows based on some condition. Out of these rows,
two rows are hidden using some other condition. I tried the following: Worksheets(1).Rows("41:44", "47:51").Hidden = False (Rows 45 & 46 are to remain hidden) But this is not working. Please help. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
hide multiple rows
Try this:
Worksheets(1).Range("41:44, 47:51").EntireRow.Hidden = False "Amit" wrote: I would like to unhide a few rows based on some condition. Out of these rows, two rows are hidden using some other condition. I tried the following: Worksheets(1).Rows("41:44", "47:51").Hidden = False (Rows 45 & 46 are to remain hidden) But this is not working. Please help. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
hide multiple rows
Amit,
try it this way: With Worksheets(1) Union(.Range("41:44"), .Range("47:51")).Rows.Hidden = False End With -- Hope that helps. Vergel Adriano "Amit" wrote: I would like to unhide a few rows based on some condition. Out of these rows, two rows are hidden using some other condition. I tried the following: Worksheets(1).Rows("41:44", "47:51").Hidden = False (Rows 45 & 46 are to remain hidden) But this is not working. Please help. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
hide multiple rows
Dear Cory & Vergel
Thanks to both of you. It worked both ways. "Amit" wrote: I would like to unhide a few rows based on some condition. Out of these rows, two rows are hidden using some other condition. I tried the following: Worksheets(1).Rows("41:44", "47:51").Hidden = False (Rows 45 & 46 are to remain hidden) But this is not working. Please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I hide multiple rows under one row IN EXCEL? | Excel Worksheet Functions | |||
| Specify which rows to NOT hide, and have excel hide the rest | Excel Programming | |||
| Hide and unhide rows for multiple areas | Excel Programming | |||
| How to Specify Multiple Rows to Hide | Excel Programming | |||
| Macro to hide multiple rows | Excel Programming | |||
Linear Mode
