| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Doesn't work as it SHOULD .. Rows.Hidden /with SpecialCells
Hello genious,
I have a problem. I want to show the rows where a formula in A:A make a number instead of "". I want to do this in the range with name "rngname_rows" but always want to show the rows 6, 209, 412 and 615 within the named range. Here is what I try to do: Sub ShowNumRows Rows.Hidden = False Range("RNGNAME_ROWS").SpecialCells(xlCellTypeFormu las, 1).Rows.Hidden = False Application.Union(Rows(6), Rows(209), Rows(412), Rows(615)).EntireRow.Hidden = False End Sub To test the parts: Selecting right rows work fine with: Range("RNGNAME_ROWS").SpecialCells(xlCellTypeFormu las, 1).Rows.Select Application.Union(Rows(6), Rows(209), Rows(412), Rows(615)).Rows.Select Why doesn't it work with hiding all cells and then just show the one I want? What can I do? Please help me, I really can't see what is wrong! /Gunnar |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Doesn't work as it SHOULD .. Rows.Hidden /with SpecialCells
Range("RNGNAME_ROWS").SpecialCells(xlCellTypeFormu las, 1).EntireRow.Hidden =
False -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Gunnar Johansson" wrote in message ... Hello genious, I have a problem. I want to show the rows where a formula in A:A make a number instead of "". I want to do this in the range with name "rngname_rows" but always want to show the rows 6, 209, 412 and 615 within the named range. Here is what I try to do: Sub ShowNumRows Rows.Hidden = False Range("RNGNAME_ROWS").SpecialCells(xlCellTypeFormu las, 1).Rows.Hidden = False Application.Union(Rows(6), Rows(209), Rows(412), Rows(615)).EntireRow.Hidden = False End Sub To test the parts: Selecting right rows work fine with: Range("RNGNAME_ROWS").SpecialCells(xlCellTypeFormu las, 1).Rows.Select Application.Union(Rows(6), Rows(209), Rows(412), Rows(615)).Rows.Select Why doesn't it work with hiding all cells and then just show the one I want? What can I do? Please help me, I really can't see what is wrong! /Gunnar |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
No, doesn't matter if it is "EntireRow" or "Rows"
No, it doesn't matter
/regards Gunnar "Bob Phillips" skrev i meddelandet ... Range("RNGNAME_ROWS").SpecialCells(xlCellTypeFormu las, 1).EntireRow.Hidden = False -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Gunnar Johansson" wrote in message ... Hello genious, I have a problem. I want to show the rows where a formula in A:A make a number instead of "". I want to do this in the range with name "rngname_rows" but always want to show the rows 6, 209, 412 and 615 within the named range. Here is what I try to do: Sub ShowNumRows Rows.Hidden = False Range("RNGNAME_ROWS").SpecialCells(xlCellTypeFormu las, 1).Rows.Hidden = False Application.Union(Rows(6), Rows(209), Rows(412), Rows(615)).EntireRow.Hidden = False End Sub To test the parts: Selecting right rows work fine with: Range("RNGNAME_ROWS").SpecialCells(xlCellTypeFormu las, 1).Rows.Select Application.Union(Rows(6), Rows(209), Rows(412), Rows(615)).Rows.Select Why doesn't it work with hiding all cells and then just show the one I want? What can I do? Please help me, I really can't see what is wrong! /Gunnar |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Work around to SpecialCells(xlCellTypeBlanks)... | Excel Discussion (Misc queries) | |||
| =ROW-1, =SUBTOTAL(3,$B$2:$B2) don't work in hidden rows. | Excel Programming | |||
| VBA ON ERROR does not work with SPECIALCELLS | Excel Discussion (Misc queries) | |||
| Help to hide rows, SpecialCells(xlCellTypeBlanks) doesn't work... | Excel Programming | |||
| SpecialCells Doesn't Work in a Function?? | Excel Programming | |||
![Gunnar Johansson[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
