+ Reply to Thread
Results 1 to 9 of 9

Correction in VBA scripts

  1. #1
    Registered User
    Join Date
    11-14-2011
    Location
    Dusseldorf, Germany
    MS-Off Ver
    Excel 2003
    Posts
    97

    Correction in VBA scripts

    Hello,

    I have some scripts and would like to make some changes to them. Need your help

    1. The below code, compares value from C column with some result in A column only when B column is blank and copies the B,C,D,E cells. I want to add a second "round" of comparing where the program will compare the value of the C with C column(yes this is not mistake) and if they 100% match copy B,C,D,E...

    Please Login or Register  to view this content.
    2. The below code locates some words and again, it is executed on these lines were the B column is empty. how can we change that, and execute it on lines were B column is empty plus on lines where the B and C contains info but the D column is empty?

    Please Login or Register  to view this content.
    Thank you in advance

  2. #2
    Registered User
    Join Date
    11-14-2011
    Location
    Dusseldorf, Germany
    MS-Off Ver
    Excel 2003
    Posts
    97

    Re: Correction in VBA scripts

    Hello... any suggestions here?

    Thank you very much!

  3. #3
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: Correction in VBA scripts

    can you attach the excel file?
    Regards,
    Khaled Elshaer
    www.BIMcentre.com

    Remember To Do the Following....
    1. Thank those who have helped you by clicking the Star below their post.
    2. Mark your post SOLVED if it has been answered satisfactorily:
    • Select Thread Tools (on top of your 1st post)
    • Select Mark this thread as Solved

  4. #4
    Registered User
    Join Date
    11-14-2011
    Location
    Dusseldorf, Germany
    MS-Off Ver
    Excel 2003
    Posts
    97

    Re: Correction in VBA scripts

    Attached example file with a more detailed explanation for the first code...
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-14-2011
    Location
    Dusseldorf, Germany
    MS-Off Ver
    Excel 2003
    Posts
    97

    Re: Correction in VBA scripts

    Attached example file for the second code...

    thank you
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    11-14-2011
    Location
    Dusseldorf, Germany
    MS-Off Ver
    Excel 2003
    Posts
    97

    Re: Correction in VBA scripts

    Hello,

    Any suggestions?

    Thank you

  7. #7
    Registered User
    Join Date
    11-14-2011
    Location
    Dusseldorf, Germany
    MS-Off Ver
    Excel 2003
    Posts
    97

    Re: Correction in VBA scripts

    Hello... sorry again... but really need your help! thank you !

  8. #8
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: Correction in VBA scripts

    I can't do it. So sorry buddy

  9. #9
    Registered User
    Join Date
    11-14-2011
    Location
    Dusseldorf, Germany
    MS-Off Ver
    Excel 2003
    Posts
    97

    Re: Correction in VBA scripts

    Thank you for the try!

    Still hope someone will help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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