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.![]()
Please Login or Register to view this content.
Any ideas?
Thanks!
Bookmarks