UCASE... with Office 2010

[Yves]

Hi,

Any reason why that in the 2010 version. the UCASE function need to be
used like so : VBA.Ucase()...


Thanks

 

[Dave Peterson]

I've never used xl2010, but when you have to use this kind of syntax in earlier
versions, it usually means that a reference (tools|References inside the VBE)
for this project is missing.

I bet it's the same symptom of that missing reference in xl2010.

If you uncheck that missing reference, I bet the problem goes away. But if your
workbook actually needed that reference, then you'll have other problems that
you'll have to address.

 

[Jim Rech]

A naked Ucase works fine for me in Excel 2010. I tried removing the
reference to test Dave's idea but I got a "can't remove..." message even in
a new workbook with no code.