Mid, Left, Right Function Macro Error

  • Hi there!

    I've got a little application in excel using macros.
    It worked perfectly with Excel 2000, but with Excel 2003 shows an error for every formula I've used in the macro -right, left, mid, date...

    Does anyone know how to fix it?

    THX in advance

    Please use code tags rather than color tags for code

  • Re: Error In Macro With Text Functions

    It's to do with the references you have defined and the order in which they are defined.

    Goto VBE->Tools->References and make sure:

    Visual Basic For Applications
    Microsoft Excel 9.0 Object library (or greater)
    Office 9.0
    OLE Automation

    Are checked.



  • Re: Error In Macro With Text Functions

    Thank you for your help.
    The problem was because of references as you noticed. Although it was the opposite. An external programm activated a library in the file, even if it wasn't necessary. Because of that some macros crashed whenever used in a PC without the external programm.

    Thanks again,

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!