Posts by fallsxr

    Your formula string needs to be in English in the code:


    Code
    1. Range("B2").Formula = "=COUNTIF(B4:B" & UltimoAssociado & ",""P"") / (COUNTIF(B4:B" & UltimoAssociado & ",""P"") + (COUNTIF(B4:B" & UltimoAssociado & ",""F"")))"

    Thank you so much, I was stuck on this for 2 days, hahah

    Hi, when I run the macro, it should give me a percentage on the cell b2, but instead, I'm receiving an #name? error that can be fixed just clicking in the code on excel and pressing enter and the formula still the same, why it doesn't start to run the percentage automatic and how it can be fixed?


    here is my code