+ Reply to Thread
Results 1 to 3 of 3

Excel 2013 VBA - Find value in named range

  1. #1
    Registered User
    Join Date
    07-29-2013
    Location
    Colorado
    MS-Off Ver
    Excel 2007
    Posts
    19

    Excel 2013 VBA - Find value in named range

    Hi All,

    I have two named ranges, one called CRConcat and MUWConcat. I'm looking for VBA coding that can check each cell in the range CRConcat and if the cell is not found in the MUWConcat range, then I would like to have the value pasted in cell K2 (and then use an activecell.offset reference to change this for each cell). Would anyone be able to help me out with this?

    Thanks,

    Jeff

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Excel 2013 VBA - Find value in named range

    Are both ranges single column/row ranges?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    07-29-2013
    Location
    Colorado
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Excel 2013 VBA - Find value in named range

    They are single column named ranges.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. find dimensions of named range
    By vizzkid in forum Excel General
    Replies: 8
    Last Post: 04-16-2013, 08:34 AM
  2. Code to find named range doesn't find the correct field range?
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-12-2012, 05:54 PM
  3. find within a named range, then deselect the range
    By Bob Mouldy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-22-2006, 03:25 PM
  4. Find Named Range
    By pianoman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-19-2006, 06:35 AM
  5. How to find all formulas that used a certain named range
    By Laurence Lombard in forum Excel General
    Replies: 2
    Last Post: 10-25-2005, 04:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1