Excel, VBA - error 13 RRS feed

  • Question

  • Trying to figure out why I'm getting and Error 13 mismatch. The array runs perfect on all computers but one and throws the error code every time. 

    I'm thinking that it's a selector in options or a formula function that could be turned off on that machine. 


    05/26/17 09:23:01  [Copy of Matrix creator.xlsm]MCreateBallotMatrix.CreatePivotTable(), Error 13: Type mismatch
    05/26/17 09:23:01  [Copy of Matrix creator.xlsm]MCreateBallotMatrix.CreateBallotMatrix(), Error 13: Type mismatch

    thank you in advance for any assistance. 


    Tuesday, June 6, 2017 4:51 PM

All replies

  • Hi Joesph MacLean,

    Whats code are you using and which line did you get the error? What's the office version in the computer? Is it different with other computer? Have you tried to repair the office application? According to the error message, I think you are creating a pivot table, did you get any error if you create the pivot table manually? Could you tell me what steps did you do before getting the error? Besides, I suggest you share your code so we could try to reproduce your issue.

    Best Regards,


    Wednesday, June 7, 2017 9:35 AM