UCASE... with Office 2010

  • Thread starter Thread starter Yves
  • Start date Start date
Y

Yves

Hi,

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


Thanks
 
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.
 
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.
 
Back
Top