Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel
I want to set up a logical condition : If a specific cell is blank then hide
row. Can this be done and how would you recommend implementing |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel
You would need a macro to do that.
Here's an example of a macro that hides rows: Sub HideRow() 'Hides rows 1:2 Rows("1:2").Select Selection.EntireRow.Hidden = True End Sub -- Brevity is the soul of wit. "cdstorage" wrote: I want to set up a logical condition : If a specific cell is blank then hide row. Can this be done and how would you recommend implementing |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel
I neglected to include the test for a blank cell in my original post.
Assume you put a formula in cell B5 that tests whether B2 is blank, and if B2 is blank, you have a 1 entered in B5: =IF(ISBLANK(B2),1,""). Then you can use the following macro to hide rows 1:2 Sub Hiderows() If Range("B5") = 1 Then Rows("1:2").Select Selection.EntireRow.Hidden = True Else Rows("1:2").Select Selection.EntireRow.Hidden = False End If End Sub -- Brevity is the soul of wit. "cdstorage" wrote: I want to set up a logical condition : If a specific cell is blank then hide row. Can this be done and how would you recommend implementing |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel
Dave
What is I'm looking for all cells in column a that are blank and if true I want to hide the entire row "Dave F" wrote: You would need a macro to do that. Here's an example of a macro that hides rows: Sub HideRow() 'Hides rows 1:2 Rows("1:2").Select Selection.EntireRow.Hidden = True End Sub -- Brevity is the soul of wit. "cdstorage" wrote: I want to set up a logical condition : If a specific cell is blank then hide row. Can this be done and how would you recommend implementing |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel
Auto-filter the range, and Show non-blanks?
-- David Biddulph "cdstorage" wrote in message ... I want to set up a logical condition : If a specific cell is blank then hide row. Can this be done and how would you recommend implementing |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel
Dave
A little more help if you can I need to look at all cells in column a & b, for blanks, if cell a% and cell b% tehn hide row "Dave F" wrote: I neglected to include the test for a blank cell in my original post. Assume you put a formula in cell B5 that tests whether B2 is blank, and if B2 is blank, you have a 1 entered in B5: =IF(ISBLANK(B2),1,""). Then you can use the following macro to hide rows 1:2 Sub Hiderows() If Range("B5") = 1 Then Rows("1:2").Select Selection.EntireRow.Hidden = True Else Rows("1:2").Select Selection.EntireRow.Hidden = False End If End Sub -- Brevity is the soul of wit. "cdstorage" wrote: I want to set up a logical condition : If a specific cell is blank then hide row. Can this be done and how would you recommend implementing |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel docs not saving as excel docs | Excel Discussion (Misc queries) | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |