Return empty cell from formula in Excel – Stack Overflow
Posted by jpluimers on 2019/11/19
I never thought you could do it, but you can: [Archive.is] Return empty cell from formula in Excel – Stack Overflow.
You have to crate:
- a VBA function
- a reference to a range that evaluates the function so it returns blank
- a cell with a function that blanks the cell using the range
Convoluted, but clever!
–jeroen
Leave a Comment