Excel treats copied empty cells as not empty

[Cosmos75]

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]

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.

 

[eliW]

This should also help you!
http://www.mrexcel.com/board/viewtopic.php?
topic=1812&forum=2
Any way you may also use find " " replace ""
Eli

 

[Cosmos75]

THANKS, eliW!!

 

[Cosmos75]

THANKS, eliW!!