I have a spreadsheet with over 46,000 rows. around half are blank. I need to
remove all these blank rows, so I can add about 30,000 more. The problem is
this....the rows are not really blank. They have expressions in those cells
that, when calculated, solve to "". The length of the string is 0, but there
is still an expression there, so I am assuming that is why none of my
functions/vba have worked so far. Any ideas? I don't care if the solution
is DeleteAllEmptyCells or DeleteEmptyRows, or whatever. I'm stuck. Thanks
for the help.