Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
mid function causes a compile error
Hi all, I have a problem that I cannot solve.
I have a routine that prints various registers for groups of pupils. the routine checks each of the controls on a userform if the control is a checkbox and its value is true then the caption of the checkbox is analysed. This is where the problem occurs. I am using the following code, whenever I run the sub, I get an error message along the lines of "compile error: cannot find project or library" Here's the code - For Each thing In RotationRegisterForm.Controls If Mid(thing.Caption, 1, 2) = "11" Then ActiveSheet.Range("rotStart11Dates").Range("a4").S elect the rest of my code follows I'm not sure what to do about it. Also whenever I am naming a range of cells in excel I get an identical error message to the one above. Is the problem caused by one of the names I have chosen for a range? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to use INDEX function in VBA Code, compile error | Excel Programming | |||
Help With - Compile Error: Sub or Function Not Defined | Excel Programming | |||
Chrw function giving compile error. | Excel Programming | |||
compile error: expected variable or function | Excel Discussion (Misc queries) | |||
compile error using Left() function | Excel Programming |