View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeroen Kluytmans Jeroen Kluytmans is offline
external usenet poster
 
Posts: 9
Default Strange error message

Hello,

I programmed a Macro in VB. Then I recieved another computer (I even
think the software was unchanged, versions etc.) but now I get an
error message withe the code below

If Sheets("Main").Range("$H$29") = False Then
Response = MsgBox("You did not select a batch" & Chr(10) &
"Please select one or more batches", vbExclamation, "Warning")
Exit Sub
End If

I recieve the message Compile Error: Can't find object or library.

It seems that the error is caused by the Chr(10), but removing that
does not help.

In other Macro's I also use message boxes and Chr(10) returns, there
it does not invoke a problem. It seems to be quite random. Anyone got
a clue?

Kind regards,
Jeroen Kluytmans