Delete Cells In Column With Content

[Logit]

.
.
I can clear the contents from cells in a specific range by :

Please Login or Register  to view this content.

.
.
Say A8; A23; A30:A45, A67 all have content. But all the other cells don't. BUT, you never know what cells in the column will have content. What is the syntax for clearing only cells in a single column that have content ?

Thanks !

[alansidman]

Probably a loop with a If-then scenario.

Additionally, here is a thread I found that takes a different approach

http://www.mrexcel.com/forum/excel-q...lications.html

[Logit]

,
Got it figured out.
.

Please Login or Register  to view this content.

Thank you.