View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
cucchiaino cucchiaino is offline
external usenet poster
 
Posts: 28
Default 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