Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you hide a row based upon cell criteria?
I am trying to get a spreadsheet to hide the rows that do not have a day
number in the left most cell. If I put the formula in the other cells, it will be overwritten when data is put into them for months that have more than 28 days. Specifically, The date is entered in cell A7. The formula in A40 is "=IF(DAY($A$7+28)<DAY(A39),"",$A$7+28)". The formula in A41 is "=IF(DAY($A$7+29)<DAY(A39),"",$A$7+29)". The formula in A43 is "=IF(DAY($A$7+30)<DAY(A39),"",$A$7+30)". If the result or the formula enters "" in the cell, I want to hide that row. I would like the macro to run each time the date in A7 is changed. I am a novice with visual basic. Is there a reference that I should have to get started understanding this language? Thanks again, Jim *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide row based on cell value | Excel Worksheet Functions | |||
Hide row based on cell value | Excel Worksheet Functions | |||
Macro to hide and unhide based on criteria | Excel Discussion (Misc queries) | |||
Is there a way to HIDE a row based on a value of a cell ? | Excel Discussion (Misc queries) | |||
Hide Row Based on cell value | Excel Programming |