J-Walk & Associates, Inc.

Problems With Euro Currency Tools Add-In

If you're experiencing some inexplicable errors with your VBA code, check your add-ins list (press Alt+TI). If Microsoft's Euro Currency Tools add-in is installed, uninstall it. That add-in should be banned. Euro Currency Tools is the only add-in I've seen that can cause errors in VBA code that's in a completely different workbook.

Try this in Excel 2007...

First, make sure the Euro Currency Tools add-in is installed. Activate a worksheet that has a few formulas, and then run this macro:

Sub TestEuroTool()
  Dim WorkRange As Range
  On Error Resume Next
  Set WorkRange = ActiveSheet.UsedRange.SpecialCells(xlCellTypeFormulas, 23)
  Debug.Print WorkRange.Count 'formula cells
  Debug.Print Err.Number, Err.Source
End Sub 

Err.Number should be 0, since the sheet has formulas. But it's 9 (Subscript Out of Range), and the source of the error is Euro Tool (the name of the VBA project in EUROTOOL.XLAM) . At least a dozen PUP users have notified me of an error -- and uninstalling the Euro Currency Tools add-in fixes the problem.

It seems to be fixed in Excel 2010 beta.