Excel treats copied empty cells as not empty

**Cosmos75** · Mar 26th, 2002, 10:05 AM

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!

**Aladin Akyurek** · Mar 26th, 2002, 10:10 AM

On 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!

Try to use the VBA equivalent of LEN as in

=LEN(A1)=0

in your code.