Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Strange Message when opening workbook | Excel Discussion (Misc queries) | |||
Strange message when Excel starts. | Excel Discussion (Misc queries) | |||
Strange error | Setting up and Configuration of Excel | |||
Strange message? | New Users to Excel | |||
Strange Error Message | Excel Discussion (Misc queries) |