Hi everyone,

I'm trying to clear the contents of a row within a specific column range if the associated cell in a different column is blank. I have the following code:

Sheets("aaa").Range("B10:B2009").SpecialCells(xlCellTypeBlanks).Offset(0, 2).ClearContents
This works great if I'm only selecting one cell to clear, but I need to be able to clear the cells in columns D:AF rather than just D. I'm not certain if offset can be used to select a range of cells in a row.

Any ideas?

Thanks!