Excel Problem

[A[L]C]

Hi all,

Got a problem with Excel over citrix. On some of our servers, my macro runs fine, however, on others it fails. Can anyone help with what reference we need to add to the systems?



TIA

 

[A[L]C]

Hi,

Worked it out... a reference is missing but I couldnt find which one. So instead of just left you can use Strings.Left or VBA.Strings.Left.

Found from http://www.mrexcel.com/archive2/28900/32969.htm