ClearContents with IF statement

**cbrd** · 12-28-2012, 09:10 AM

I have a worksheet with 15 rows (row 4 thru 19) and 4 columns (column A thru D)

I need a macro that does the following for each row:

If the value of D in a row = "Recorded"
then
ClearContents of column B, C, and D in that row

Thanks

**JosephP** · 12-28-2012, 09:12 AM

Please Login or Register  to view this content.

**Andrew-R** · 12-28-2012, 09:14 AM

Try this:

Please Login or Register  to view this content.

**cbrd** · 12-28-2012, 09:18 AM

Thanks you 2, worked great

**AB33** · 12-28-2012, 09:18 AM

Yet another one

Please Login or Register  to view this content.

**JosephP** · 12-28-2012, 09:32 AM

@AB33

Please Login or Register  to view this content.

that would clear the entire column not just the relevant row

**JosephP** · 12-28-2012, 09:33 AM

@cbrd,

you're welcome :-)

please don't forget to mark the thread solved (click the 'thread tools' link at the top, then 'mark solved')

**AB33** · 12-28-2012, 09:52 AM

Jay,
Thanks Jay for your correction!
Had I seen your code before I posted it,I would have refrained from doing so, as I had ended-up with the same code as his highness.