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:
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.![]()
Sheets("aaa").Range("B10:B2009").SpecialCells(xlCellTypeBlanks).Offset(0, 2).ClearContents
Any ideas?
Thanks!
Bookmarks