+ Reply to Thread
Results 1 to 6 of 6

NOT expected result in macro

  1. #1
    Registered User
    Join Date
    09-02-2019
    Location
    spain
    MS-Off Ver
    2016
    Posts
    3

    NOT expected result in macro

    Hello, my macro should do the following. It must be verified that all the “Project Code” declared in sheet 1704 are reflected in the “Project Code” field of sheet 1701. It works fine but when the same code is put several times on sheet 1704, it tells me that the code is not found on sheet 1701.

    Please Login or Register  to view this content.
    sheet 1701

    Code Name
    CW222222 Sondaje


    sheet 1704

    Code System
    CW222222 220
    CW222222 220
    CW222222 220
    CW222222 220
    CW222222 220
    CW222222 220


    Result

    CW222222
    CW222222
    CW222222
    CW222222
    CW222222
    CW222222


    Expected result

    no code, since it is found on sheet 1701

    please help, I'm stuck

  2. #2
    Registered User
    Join Date
    09-02-2019
    Location
    spain
    MS-Off Ver
    2016
    Posts
    3

    Re: NOT expected result in macro

    ?? plaese help

  3. #3
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: NOT expected result in macro

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  4. #4
    Registered User
    Join Date
    09-02-2019
    Location
    spain
    MS-Off Ver
    2016
    Posts
    3

    Re: NOT expected result in macro

    I cant im new in the forum

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: NOT expected result in macro

    Also cross posted at MrExcel.
    Rory

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: NOT expected result in macro

    1. Yes you can. Re-read the instructions at Post 3. You cannot post links, but you CAN upload the file (< 1Mb) DIRECTLY.

    2. Please do not cross-post, without telling us about it. This is very annoying for potential helpers., who could spend a lot of their time freely trying to help you find a solution to the problem that has been solved elsewhere. Not declaring a cross-post is a huge abuse of our good will. DON'T DO IT!!

    Cross-post here:

    https://www.mrexcel.com/forum/excel-...ult-macro.html

    Next time, expect your thread to be locked down until YOU declare the URL.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ 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] Joining to formula not given expected result
    By Excelski in forum Excel General
    Replies: 6
    Last Post: 12-20-2018, 08:32 AM
  2. not getting expected result
    By Patcheen in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-30-2018, 09:51 AM
  3. Getting zero when a non-zero result is correct and expected.
    By fred3 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-30-2014, 12:05 AM
  4. Macro returns expected result
    By cossie2k in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-09-2012, 08:25 AM
  5. SUMIF - not returning expected result
    By Paul Sheppard in forum Excel General
    Replies: 4
    Last Post: 08-16-2011, 11:43 AM
  6. Recorded macro doesn't seem to provide expected result
    By Jeroen1000 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-21-2009, 06:52 AM
  7. Using sum(1/countif....) not returning expected result
    By Kent (thanks) in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 05-11-2006, 11:40 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