meangreen
Board Regular
- Joined
- Jan 29, 2007
- Messages
- 169
In R25:R68 I have a formula that reluts in a "1" or a "0". The formula in R25 would be this: =if(A25<=$B$7,1,0). The formula in R26 would be the same but would reference A26 and so on. Basically, if any cell in A25:A68 is less than B7 then the corresponding cell in R25:R68 will be 1. If greater than it will equal 0.
Now I want to create a macro that will hide the rows from 25 thru 68 that have a 0 in coulmn R. They would also need to unhide as B7 will be changing all of the time. Any ideas?
Now I want to create a macro that will hide the rows from 25 thru 68 that have a 0 in coulmn R. They would also need to unhide as B7 will be changing all of the time. Any ideas?