• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. Belleke

    Macro to send PDFs in Email?

    Glad to help:)
  2. Belleke

    Macro to send PDFs in Email?

    Does this help?
  3. Belleke

    Workbook doesn(t want to save

    Got it, thanks for the explanation.
  4. Belleke

    Workbook doesn(t want to save

    problem solved, stupid me Thanks Narayank991
  5. Belleke

    Workbook doesn(t want to save

    example
  6. Belleke

    Workbook doesn(t want to save

    Tried it before. It gives me error 1004
  7. Belleke

    Workbook doesn(t want to save

    I have this code Sub Belle() Range("A2:R50").Copy Workbooks.Add With ActiveSheet .PasteSpecial .PasteSpecial xlPasteColumnWidths End With Path = "C:\test\" Filename = ActiveSheet.Range("P7") ActiveWorkbook.SaveAs Filename:=Path & Filename & ".xlsm", FileFormat:=52 ActiveWindow.Close End...
  8. Belleke

    5 highest values formula

    Thanks
  9. Belleke

    5 highest values formula

    I have this formula in one cell =INDEX(C2:C411,MATCH(MAX(P2:P411),P2:P411,0)) What would be the formulas to display the five highest scores in five cells. The names are in column C, scores are in column P There can be identical scores. Thanks
  10. Belleke

    User Form entry sheet Validation check

    You're welcome :)
  11. Belleke

    User Form entry sheet Validation check

    Like this? If the Warrant Number entry is the same as the Stock Code field then you get an error message.
  12. Belleke

    User Form entry sheet Validation check

    Something like this? The comboboxes and the textboxes are mandatory fields. If you enter something in a combobox that are not in the combobox list you get an error message. In the Warrant Number field you only can enter numbers.
  13. Belleke

    Color userform labels background from listbox selection.

    I am looking for a code that changes the background color of labels. If I use Select case the code will be long. I wonder if it' s possible to have another one with a shorter code. thanks
  14. Belleke

    Values instead of formulas

    Hi vletm, It seems that this does what I want. Thank you for helping.
  15. Belleke

    Values instead of formulas

    That is not what I want, I want to have some help with this code to solve the formula problem. And can someone move this thread to the VBA section, I was not aware I was in the wrong section.
  16. Belleke

    Values instead of formulas

    May I hAve the title of this thread?
  17. Belleke

    Values instead of formulas

    @ Marc L This is what I call a contribution that's of use to me, total nonsense.
  18. Belleke

    Values instead of formulas

    I still get errors. New more realistic example.
  19. Belleke

    Values instead of formulas

    I saw it. I'll let you know when I tested it. Thanks.
  20. Belleke

    Values instead of formulas

    I added this line of code and I get what you see in #5. j20.Cells(lrJ20, "A") = .Cells(i, "D")
  21. Belleke

    Values instead of formulas

    You mean this? after should be before as You could notice.
  22. Belleke

    Values instead of formulas

    #6 is a picture??
  23. Belleke

    Values instead of formulas

    The goal is to copy the rows that have an x in column G from the result sheets to the Jabpsheet, In the result sheets, there are formulas in column A like the formula above. But in the Jap sheet the formulas should be replaced with the values. I used your code from # 4 but then I get what you...
  24. Belleke

    Values instead of formulas

    Formula =IF(B9="",""&C9,LEFT(B9, FIND(" ",B9)-1) & "."&COUNTIF($B$8:B9,B9))
Top