Hi, I have searched and cannot find an answer. I am also trying to teach myself VBA so even something as simple as what I am trying to do seems hard to me (at the moment).
I have two columns of data, column A and column B that are copied from another workbook.
The columns generally be anywhere from 5 to 800 rows that has data in them. Some of these values are a result of a formula, so they may have "" as a value. Any cells in column A that has a "" result in it, then column B will also be "".
I have the code below that will delete the "" from columns A and B but will also attempt to do the same to column C which performs funtions based in Columns A and B.
So, after all that, how would I get this code to only delete "" from columns A and B, not Column C as well.
Please Login or Register to view this content.
Thanks in advance.
Bookmarks