Application Defined or Object Defined error when using Formula2R1C1

%3CLINGO-SUB%20id%3D%22lingo-sub-1531089%22%20slang%3D%22en-US%22%3EApplication%20Defined%20or%20Object%20Defined%20error%20when%20using%20Formula2R1C1%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1531089%22%20slang%3D%22en-US%22%3E%3CP%3ETeam%2C%3C%2FP%3E%3CP%3ENeed%20help%20on%20this.%26nbsp%3B%20I%20have%20implemented%20a%20code%20line%20in%20excel%20that%20works%20locally%20in%20my%20own%20O365%20Excel%20but%20is%20not%20working%20and%20encountering%20that%20Application%20Defined%20or%20Object%20Defined%20Error%20from%20another%20user%20and%20another%20PC.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAppreciate%20if%20some%20one%20could%20help%20me.%26nbsp%3B%20I%20have%20attached%20a%20sample%20screenshot%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1531089%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1531093%22%20slang%3D%22en-US%22%3ERe%3A%20Application%20Defined%20or%20Object%20Defined%20error%20when%20using%20Formula2R1C1%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1531093%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F732731%22%20target%3D%22_blank%22%3E%40willmabrin%3C%2FA%3E%26nbsp%3B%2C%20looks%20like%20you%20are%20using%20the%20new%20Excel%20functions.%20Perhaps%20the%20other%20user%20does%20not%20have%20the%20latest%20version%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Team,

Need help on this.  I have implemented a code line in excel that works locally in my own O365 Excel but is not working and encountering that Application Defined or Object Defined Error from another user and another PC.  

 

Appreciate if some one could help me.  I have attached a sample screenshot

1 Reply

@willmabrin , looks like you are using the new Excel functions. Perhaps the other user does not have the latest version?