VBA Help needed to clear cell contents if the Column “B” cell is blank

**krjoshi** · 06-19-2014, 04:23 AM

Folks,

Please help me to write a vba code to clear all cells contents of Column “A:BC” if the Column “B” Cell is blank.

I have attached the workbook for more details.

Thank you so much in advance.

**AB33** · 06-19-2014, 04:42 AM

Try the attached.

**krjoshi** · 06-19-2014, 04:54 AM

Hi AB33,

Great code...working perfect...Thank you so much.

Joshi

VBA Help needed to clear cell contents if the Column “B” cell is blank

LinkBack

Thread Tools

Rate This Thread

Display

VBA Help needed to clear cell contents if the Column “B” cell is blank

Re: VBA Help needed to clear cell contents if the Column “B” cell is blank

Re: VBA Help needed to clear cell contents if the Column “B” cell is blank

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] move down column and for every blank cell, clear contents of cell to the left

[SOLVED] Macro to clear cell contents in all but 1 column of specified rows

Clear Contents of every other cell in one column

macro to clear contents of two ranges if cell is blank

Clear contents of a cell of row A, if cell in row I is blank

Bookmarks

Bookmarks

Posting Permissions