In Excel VBA, how would you define a set of all cells that were not in a previously defined (e.g., via a Find command) set? Thanks.
Printable View
In Excel VBA, how would you define a set of all cells that were not in a previously defined (e.g., via a Find command) set? Thanks.
It's difficult to understand what you need, but there is a Range object.
Doing: Set f = .Find("=", lookin:=xlFormulas) to find all cells in the range that contain a formula. I want to work on cells in the same range that do not contain a formula.