+ Reply to Thread
Results 1 to 3 of 3

If search term is not found when naming a range.

  1. #1
    Registered User
    Join Date
    08-03-2012
    Location
    Edmonton, Alberta, Canada
    MS-Off Ver
    Excel 2007
    Posts
    11

    If search term is not found when naming a range.

    I'm looking for a way to skip a line of code if the search term is not found.
    I'm searching for payment types (Bank Draft, Cheque, Bpay, etc.) and naming that column for use in formulas in the next worksheet.

    In this case I can't find BPay so I want it to skip that naming and go to the next search term.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: If search term is not found when naming a range.

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    08-03-2012
    Location
    Edmonton, Alberta, Canada
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: If search term is not found when naming a range.

    Thank you so much. I knew it was something simple.
    Your quick reply is greatly appreciated!

+ 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. [SOLVED] Search for value in row. if found, copy column formulas into found column range
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-23-2017, 10:42 AM
  2. [SOLVED] Possible use of VBA to clear cell content if a search term is found
    By s_bruno1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-17-2017, 08:33 AM
  3. help with range.find method not finding search term
    By excel_joe in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-22-2016, 07:20 PM
  4. Search for value in a range and overwrite if found and create new if not found
    By mm671750 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-04-2016, 01:19 PM
  5. Replies: 10
    Last Post: 11-04-2015, 05:19 AM
  6. If a search term can be found 1 time, 2 times 3 times 4 times 5 times
    By excelcandy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-10-2013, 09:57 PM
  7. Replies: 3
    Last Post: 07-12-2006, 10:15 AM

Tags for this Thread

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