How do I clear contents empty cells of a page where the empty cell are part of a range that was copied? I use End(xlUp and xlDown) in a macro and I've noticed that it doesn't choose the correct range and it's treating those copied empty cells as not being empty? Is there something I can add to my existing macro to clear the "content" of the copied empty cells?
THANKS!
THANKS!