+ Reply to Thread
Results 1 to 2 of 2

Check if range already added to sheet

  1. #1
    Forum Contributor
    Join Date
    06-28-2004
    MS-Off Ver
    Home/Office 2016
    Posts
    246

    Check if range already added to sheet

    E10 holds the formula, but when i expand it to include A,B,C columns i can't get it to work
    Want to check if the data in columns A3:C3 are found in A10:C999

    When ADD RECORD is clicked, msgbox pops up saying record already exists
    if not, it will add the record to the next blank line

    attachment included
    Attached Files Attached Files
    Last edited by x65140; 11-08-2023 at 01:16 PM.

  2. #2
    Forum Contributor
    Join Date
    06-28-2004
    MS-Off Ver
    Home/Office 2016
    Posts
    246

    Re: Check if range already added to sheet

    Found resolution: A2&B2&C2,A10:A100&B10:B100&C10:C100 added a range for each & and that worked

+ 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] Trying to check if range on 1 sheet equals range on another then either continue or exit
    By bdouglas1011 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-02-2022, 01:46 PM
  2. [SOLVED] Added Check Box Name doesn't change
    By Markdk in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-01-2019, 04:00 AM
  3. [SOLVED] check to see if a person has already been added to the workbook
    By chriswrcg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-05-2018, 11:27 AM
  4. [SOLVED] Check range from one sheet against range in another sheet and then delete row if exists
    By zigojacko in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-19-2013, 12:37 PM
  5. add a check box and have weight added when box is checked
    By jamiemchick in forum Excel General
    Replies: 6
    Last Post: 12-17-2010, 03:37 PM
  6. How to add a check box for each sheet added?
    By gshock in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-25-2008, 10:58 AM
  7. How to add check boxes as sheets are added?
    By gshock in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-24-2008, 03:50 PM

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