Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an intro course with C++ but a newbie user with VB. I googled th
error, which seems pretty simple in itself, but I didn't resolve it The error is: *Block If without End If* and the code, copied right out of VB: Function UtilizationRank(Utilization As Integer) As Integer If Utilization 90 Then UtilizationRank = 1 If Utilization <= 90 And Utilization 75 Then UtilizationRank = 2 If Utilization <= 75 And Utilization 50 Then UtilizationRank = 3 If Utilization <= 50 And Untilization <= 1 Then UtilizationRank = 4 If Utilization = 0 Then UtilizationRank = 5 End If End Function Like I said, newbie prob. I'm not sure about whitespace issues either Solve my problem, give me pointers. Thanks -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
help with this error-Compile error: cant find project or library | Excel Discussion (Misc queries) | |||
Compile Error: Block If without End if | Excel Discussion (Misc queries) | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) | |||
Compile error in hidden module error | Excel Programming |