Ok, in that case if we're using a UDF we can check HasFormula to ignore those cells that have a formula but return no result, right? e.g something like [VBA]If Range("A1").HasFormula and Range("A1").Value="" Then....[/VBA]Originally Posted by xld
Ok, in that case if we're using a UDF we can check HasFormula to ignore those cells that have a formula but return no result, right? e.g something like [VBA]If Range("A1").HasFormula and Range("A1").Value="" Then....[/VBA]
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
Posting Permissions
Reply With Quote