I need to be able to delete blank lines in a macro, and the only VBA code I
can find doesn't work if there's a formula in the cell, even if the value is
zero. I tried copying and pasting special (Values), but even though the
formula isn't there any more, it still won't delete that line. I would
appreciate any suggestions.

--
Message posted via http://www.officekb.com