Try to use the VBA equivalent of LEN as inOn 2002-03-26 10:05, Cosmos75 wrote:
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!
=LEN(A1)=0
in your code.
Like this thread? Share it with others