Hi, I'd like to clear contents in cells that do not intersect with a range. Something along the lines of (or anything faster):
For each cell in sheets("responders").range("B111:B25000")
if "cell range" <> sheets("responders").range(var) then
"cell range".clearcontents
end if
next cell
"cell range" - I'm not sure how to refer to the range of each cell in the loop, e.g. B111, B112, B113, etc.
var - this is a string I've calculated elsewhere that refers to a range within ("B111:B25000").
In other words, within range("B111:B25000") I'd like to clear contents in any cells, B111, B112, B113,....B25000, that don't intersect with range(var).
I've come across the application.intersect method, but not sure if that would be better?
The alternative perhaps would be to only populate range(var) to begin with , but it takes too long to run.
Thanks