I have the following VBA code
It counts the number of cells (rows) in Column D that contains data. Say D12:D20 contain data. What I want to do is then erase the contents (not the entire row) of any cells in Columns E:H from row 21 and down that contain data. The tricky part is that the number of rows in Column D with data will always be changing. Is there a way to add to the code above that will allow me to delete the content of cells in columns adjacent to Col D starting at the point (row) where the cells in Column D are first empty?
Thanks
Code:
Set datRange = Range("D12:D" & Range("D65536").End(xlUp).Row)
numRows = datRange.Rows.Count
Thanks