Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Why am I getting an answer of 1 everytime? The function seems to be skipping
the Case programming. What do I need to do to fix this? Function TabeGECol(Level, Form) As Integer Dim ColNum As Integer ColNum = 1 Select Case Level Case Level = "L" ColNum = 2 Case Level = "E" ColNum = 10 Case Level = "M" ColNum = 18 Case Level = "D" ColNum = 26 Case Level = "A" ColNum = 34 End Select Select Case Form Case Form = 7 ColNum = ColNum + 0 Case Form = 8 ColNum = ColNum + 2 Case Form = 9 ColNum = ColNum + 4 Case Form = 10 ColNum = ColNum + 6 End Select TabeGECol = ColNum End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change data of entire column from small case to upper case | Excel Worksheet Functions | |||
Changing multiple cell text from lower case to upper case | Excel Discussion (Misc queries) | |||
How to change mixed case to upper case in Excel for all cells | Excel Discussion (Misc queries) | |||
Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
How do I change existing text from lower case to upper case | Excel Discussion (Misc queries) |