Posts by xsmurf

    Carim Just a quick update:

    I have successfully implemented the solution, see code below, and it works perfect. All the information is displayed how it should.


    The retrieval of the information is working without any problems, however when I try to SUM the results it gives me a #value error.

    The code I am using, see below, works perfectly when I type in the value manually, but when used with the first code it gives me an #Value error.

    I tried to change the condition of the cells to Number / General, but nothing seems to help.


    Would you be able to assist ?

    Thank for any help you can give me.


    This forum has also helped me a lot over the years and I hope this will be the case now.

    I know there are a lot of ways to show duplicates values in excel, but I have not seen this yet so I don't know if this is possible.
    Let's say I have a range from C5 to X70, within that range I would like to see duplicates marked red.
    But within that range there a columns and rows that need to be excluded from turning red (so duplicates are aloud in these columns & rows)
    The code should only look for doubles in columns C / E / G / I / K / M / O
    The code should ignore doubles in row 55 / 56 / 57 / 58
    So if there is a name John in column C, but also a John in column K, both John's should highlight RED.
    A John in row 56 should NOT turn RED, because this is aloud.

    I want to use this with a Worksheet_Change event in VBA, and prefer not to use conditional formatting, because there will be a lot of copy & paste happing in this sheet.

    Can anybody help me out with my problem?

    A big thanks in advance for all the help that will be offered, I really appreciate it.


    I use an userform to populate a sheet, and this works fine.

    I have added the option to edit / delete data from the data-sheet, and that works, however it updates the wrong rows when there are empty rows in the data-sheet.

    Every row of data has an serial number, their are no doubles.

    The code that I am using, just for updating (found on a forum and adapted to my needs)

    How can I change the code so it will ignore the empty rows (if there are any).

    Overwriting the wrong rows is not an option.

    Hope someone can help me, really appreciate all the help.


    I hope to get some help here with a problem that I have.

    I have a workbook that retrieves information from different workbooks, this all works well.

    The main problem I have is when there is more then 1 result.

    Please see attached file with a sample.

    Just to clarify the sample is retrieving on a different sheet within the same workbook. The solution needs to be that it needs to retrieve that information from a different workbook.

    Hope you guys can help me out, I would really appreciated it.




    I was wondering if something was possible.

    If I make a list on a sheet in cel B3 through the option " Data Validation", and fill it for example with the options "test;test1;test2"
    would it be possible to make userform that reads the list options in cell B3, show them in the userform and be able to add or remove an option?
    So if you want to remove the option "test2" you can do that from within the userform, same if you want to add a option.

    I know you can have a reference to a range of cells, but I want to know if it is possible?

    Thank you.


    I have a question, because I have a problem regarding a VBA code

    I found a code that does only partially what I want.
    I'm trying to highlight dates that are equal or lower then the current date (this date is on a different sheet, called Setup and the date is in cell "F3")
    If there is no date in the range given no formatting should take place.
    And only the range given should be highlighted, and not the rows in between the range.

    Can somebody assist me with this problem, it would be highly appreciated.

    The Code: