Is there a version of .Clear that will clear both visible and hidden cells (using an Advanced filter) in a range? I’ve found ways to clear the hidden cells, but not both in one command. I’d prefer not to unfilter the range first. I can copy a blank range from another part of the worksheet and paste it over the filtered column which works, but just seems like there should be a clear version that would do it. Anyone know? Thanks.
Bookmarks