Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Ok I have checked for postings on this problem but none of them have an
answer to my "unique" question. What I want to do is hide an entire row if the first cell is blank but the "blank" cell has a formula. For example: Lets say cell A25 has the following formula if(A24="33","Please input data"," "), so if A24 does not have the number 33 or if it is blank then the cell A25 will be blank as well, therefore I want the whole entire row to hide. If A24 has the number 33 then the row should appear with the cell A25 showing "please input data". I have found similar problems that have solutions that work but only if the cell is completely blank and with no "hidden" formulas. (I am by no means well off with VBA or programming, but ill try it if that is the only way to do so.) I hope I make some sense Thank you in advance. TG |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
auto hide blank rows | Excel Discussion (Misc queries) | |||
Auto Hide Blank Rows | Excel Discussion (Misc queries) | |||
Hide columns if specific cell is blank? | Excel Discussion (Misc queries) | |||
auto-hide rows, cell format (# and @), update cell refs, shade cel | Excel Discussion (Misc queries) | |||
macro to hide rows if cell is blank | Excel Worksheet Functions |