Add-in

[Guest]

For a professional software package we have created a xla to communicate
between the package and Excel. The strange thing is that this xla works fine
on machines in the US (Windows2000/Excel2000), but fails on machines in
Amsterdam (same system). On my machine (XP) the error message is: Runtime
Error 9: Subscript out of range". I have tested the xla on
Windows2000/Excel2000 as well on Windows XP/Excel2002 both without success.

Any suggestions....

 

[Frank Kabel]

Hi
you may post the relevant part of your code which causes this error.
Otherwise impossible to say

 

[Charles Williams]

My wild guess is that you are not using Option Compare Text, but as Frank
says we need to see the staement that causes the problem.