jenrique.cerda
Board Regular
- Joined
- Sep 22, 2006
- Messages
- 53
Hi everyone,
I´ve been having trouble chaning a cell´s value when the cell´s value equals #N/A.
I have a column which has cells with formulas and some values returned by the formula is #N/A.
How can I change this value to "Yes" comparing all the cells in this column?
I´ve tried to do a for each cell in selection but I can´t seem to get it right. I´ve noticed that when I type "#N/A" my code changes this to "Yes" but not comparing the value "#N/A" returned by the formula.
Thanks.
I´ve been having trouble chaning a cell´s value when the cell´s value equals #N/A.
I have a column which has cells with formulas and some values returned by the formula is #N/A.
How can I change this value to "Yes" comparing all the cells in this column?
I´ve tried to do a for each cell in selection but I can´t seem to get it right. I´ve noticed that when I type "#N/A" my code changes this to "Yes" but not comparing the value "#N/A" returned by the formula.
Thanks.