I am just learning about Macro's and although I don’t find them too hard I cannot figure something out.
I have several worksheets that I am combining to one master sheet. I am intentionally including blank rows because if I add to the individual worksheet info I want them to show. The blank rows return as 0 in the cells, I have tried to write a macro to delete these cells. I have tried to update them as blanks but still no luck.
I also wonder (because I have not been able to test it) if when I do update the blank cell to include info if that blank cell will then show up in the list and not be deleted.
Sorry for so many questions. Thank you in advance for your help!!!
Bookmarks