Chr() now doesn't work !

Range("A1")=Chr(34)

This works fine for me in Excel 365 Office Insider Beta Channel so I'm guessing it's not a new "feature".

What have you tried to fix it? I'd be inclined to save and close all instances of Excel and/or reboot the machine. Failing that,maybe repair Excel?

Perhaps if you upload a workbook that contains the add on routine in question then we may be able to assist further.

Originally Posted by Rick Rothstein

Try changing one of the Chr(..) to VBA.Chr(..) and see if that line of code then works.

VOILA ! That does the job ! Thank you !

If it does, that usually means you have a variable, function or subroutine within the same scope as the non-working code with the name Chr.

The error message is:-
Compile error:
Can't find project or library


BUT . . .
I pressed F5, & off it went, so I came back here to reply - but I went back to check - and :-(
It had stopped again with that same error message - but THIS time, it baulked at Left(.
Prefixing your "VBA." in front solved THAT - but THEN it stopped at Right(

Something VERY fishy here . . .

Thank you, Artik !
Alas ! I didn't understand, but see below.

You have a missing reference. Check Tools - References - one of them will be prefixed with MISSING:

Originally Posted by rorya

You have a missing reference. Check Tools - References - one of them will be prefixed with MISSING:

Thank you for that.
I checked, and YES !

MISSING: NavNLU.xla
Location: K:\Excel\LELTACS\NavNLU.xla

So thither I went, and did a search in that folder and . . .

NavNLU.xla
K:\Excel\LELTACS
Date modified: 23/06/2022 08:40
Size: 377 KB

So it IS there, but I guess I was correct; that Microsoft has downgraded / interferred, for that is the date Excel stopped working.


Now - Pretty please ? - how do I re-connect it ?
Well . . . I started to "fiddle around", and in Excel I found > Developer > Add-ins > Excel Add-ins - and THERE was the Suspect. So I clicked on it, and . . .

Microsoft Excel cannot access the file 'K:\Excel\LELTACS\NavNLU.xla'. There are several possible reasons:
• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.

Well, none of those apply, so I then went to that folder, found the file and clicked on it -

Microsoft Excel

The last time you opened 'NavNLU.xIa', it caused a serious error. Do you still want to open it?

So I clicked on "Yes", and it seems to have re-instated with (so far) no ill effects !

So all MAY be well. I shall see tomorrow !

What happens if you browse to it from the references dialog?

Also, is it required for the code in question?