Delete Blanks from Formulas using Visual Basic

[twolf]

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,

 

[Barrie Davidson]

Welcome to MrExcel!

Here's what I'd suggest (works for me):
Change the FALSE part of your IF statement to return something that wouldn't be returned for TRUE. For example, I use "zzz". Copy and paste your data. Then Find & Replace. Find "zzz" and leave the replace section blank.

Regards,

 

[twolf]

Barrie,

Thank you very much for your reply. That is the same strategy I planned on using, but I thought that there might be an easier way using a macro. Either way, the "zzz" approach will work well enough for my needs.

Thanks again,