Clear Cells If Corresponding Cell Empty

dtwk · Dec 8th 2006

Hi

If I have 2 columns A and B, I would want cells in A emptied if cells in column B is empty. Otherwise, ignore.

Any advice?

Thanks

Badger101 · Dec 8th 2006

Re: Clear Cell If Cell To The Right Is Empty

Just put a filter on blanks in column b. Then select column a and clear the contents.

dtwk · Dec 8th 2006

Re: Clear Cell If Cell To The Right Is Empty

I need a macro for this ><

Badger101 · Dec 8th 2006

Re: Clear Cell If Cell To The Right Is Empty

ok

Code

Columns("B:B").SpecialCells(xlCellTypeBlanks).Offset(0, -1).ClearContents

Participate now!