Hi,
I a novice. I am trying to use Visual Basic to delete blanks that are left when I use a formula. This is what I do:
1) Write an IF statement. If the answer is false, then I ask it to return "" (nothing).
2) I copy over the cells with the formula by pasting values.
3) The cells that had "" are still do not act blank. How do I remove all contents from those cells?
Thanks,
I a novice. I am trying to use Visual Basic to delete blanks that are left when I use a formula. This is what I do:
1) Write an IF statement. If the answer is false, then I ask it to return "" (nothing).
2) I copy over the cells with the formula by pasting values.
3) The cells that had "" are still do not act blank. How do I remove all contents from those cells?
Thanks,