|
-
Mar 4th, 2003, 02:19 PM
#1
Thread Starter
Hyperactive Member
Objects Not in set (try again)
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?
For example, 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 (i.e., an “=”).
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|