+ Reply to Thread
Results 1 to 8 of 8

Edit a small code to remove error

  1. #1
    Forum Contributor
    Join Date
    02-23-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    133

    Edit a small code to remove error

    Hello,

    Credit for the codes to Skywriter.

    In attached sheet, macro2 (StatusMove) only has the issue. It runs fine IF and ONLY if all three entries (Delivered, Hold, Rejected) are present in column H. If any of the three is missing it gives 1004 with cells not found error.

    I want it to run with any of the entries. And if H is blank, it can give message like Status is empty or something.

    Any help will be greatly appreciated.

    Please Login or Register  to view this content.
    Thank you.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Re: Edit a small code to remove error

    Hello Moon,

    Check the file now...
    Attached Files Attached Files
    Regards
    Parth

    I appreciate your feedback. Hit * if u Like.
    Rules - http://www.excelforum.com/forum-rule...rum-rules.html

  3. #3
    Forum Contributor
    Join Date
    02-23-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    133

    Re: Edit a small code to remove error

    Thanks Parth,

    When new data is pasted to sheet1, i need to compare with sheet (delivered,rejected,hold) to check if new data already does not exist in any of those sheets. If so give some warning and in sheet1 column G show message duplicate, or status etc. How can i achieve that?

    Thanks.

  4. #4
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Re: Edit a small code to remove error

    IF you have any unique column in Sheet1..
    considering Customer Number is unique you can match the column values with other sheets & plot the data in column G is found.. may be you need to see if the code can work out..

  5. #5
    Forum Contributor
    Join Date
    02-23-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    133

    Re: Edit a small code to remove error

    Can we match name mobile no and model? There is 0% possibility of all three matching.

  6. #6
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Re: Edit a small code to remove error

    Yup you can.. see if you get the code in working condition

  7. #7
    Forum Contributor
    Join Date
    02-23-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    133

    Re: Edit a small code to remove error

    Well, i am new with VBA.
    Anyways, thanks for your help.

  8. #8
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Re: Edit a small code to remove error

    Hey Moon,

    Below is sample code which match one column value from sheet1 & sheet2 & insert value in G column, you just need to see how the vlaue can be plotted

    Please Login or Register  to view this content.
    Experts please help me in getting this code work for Moon..

+ 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] Blank cell gives error 13 (Mismatch) in loop - edit code to accommodate for blanks
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-17-2015, 07:35 AM
  2. [SOLVED] Macro small edit
    By makinmomb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-08-2014, 06:10 AM
  3. [SOLVED] Remove the error and clean my code to send mail automatically from excel
    By mukeshbaviskar in forum Outlook Programming / VBA / Macros
    Replies: 9
    Last Post: 08-22-2013, 09:26 AM
  4. Error when executing VBA code to remove all formulas from Workbook
    By brharrii in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-17-2013, 05:17 PM
  5. Edit code to loop error msgbox and inputbox until valid date is entered by user.
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2012, 10:07 PM
  6. [SOLVED] Coyping results in Run-TIme Error 424, Need help to edit code
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-02-2012, 12:08 AM
  7. Getting Error 400 with following code. How do I remove it?
    By paulabrozek in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-05-2008, 12:28 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