Results 1 to 13 of 13

Thread: Adding the exact IDs

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 11-08-2012, 01:20 PM #12
    Teeroy
    Teeroy is offline
    VBAX Mentor Teeroy's Avatar
    Joined
    Apr 2012
    Location
    Sydney, Australia
    Posts
    414
    Location
    Hi hakunamatata, try the attached.

    For your information, if you reuse the DistinctValues Function and pass arrays you must set Option Base 1. I'd only used it with ranges before and found this hard way .
    Attached Files Attached Files
    _________________________________________________________________________
    "In theory there is no difference between theory and practice. In practice there is." - Chuck Reid

    Any day you learn something new is a day not wasted.
    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