Results 1 to 3 of 3

Thread: Objects not in set

  1. Mar 4th, 2003, 01:17 PM #1
    doasidont
    doasidont is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Apr 2002
    Posts
    382

    Objects not in set

    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.
    Reply With Quote Reply With Quote
  2. Mar 4th, 2003, 01:22 PM #2
    McGenius
    McGenius is offline
    Frenzied Member McGenius's Avatar
    Join Date
    Jan 2003
    Posts
    1,199
    It's difficult to understand what you need, but there is a Range object.
    McGenius
    Reply With Quote Reply With Quote
  3. Mar 4th, 2003, 01:24 PM #3
    doasidont
    doasidont is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Apr 2002
    Posts
    382
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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