I am using .EntireRow.Delete to clear data from all cells in a row. My problem is that it is clearing all of the formatting (borders, dropdown lists, etc.) how do I simply clear the data in the cells of that row without removing the row or messing up the formatting and not removing the lists?
Bookmarks