My VBA code in excel does not work on another PC
 

Ihave a code with the following line that does not work on other computer

If (StrComp(Application.WorksheetFunction.Trim(state) . "A") =0) Then
call Updatetime - this is another sub routine.

The code reads the cell which has "A" in it but it just does not call up the
sub routine. It works on my machine but does not work on another machine.

My VBA code in excel does not work on another PC
 

SMH:

Ihave a code with the following line that does
not work on other computer

If
(StrComp(Application.WorksheetFunction.Trim(stat
e). "A") =0) Then call Updatetime - this is
another sub routine.

The code reads the cell which has "A" in it but
it just does not call up the sub routine. It
works on my machine but does not work on
another machine.



If UCase(Trim(State)) = "A" Then
Call Updatetime
End If



( )---cucchiaino

My VBA code in excel does not work on another PC
 

Thank you but the original code works on my laptop but when I transfer the
spreadsheet to another machine running the same windows Xp and offcie 2003 it
just ignores this line of code. Any idea ?

"cucchiaino" wrote:

SMH:

Ihave a code with the following line that does
not work on other computer

If
(StrComp(Application.WorksheetFunction.Trim(stat
e). "A") =0) Then call Updatetime - this is
another sub routine.

The code reads the cell which has "A" in it but
it just does not call up the sub routine. It
works on my machine but does not work on
another machine.



If UCase(Trim(State)) = "A" Then
Call Updatetime
End If



( )---cucchiaino