name cases

[ndendrinos]

Can this be done?

I have 14 Case instead of multiple IF's
one by one 52 cells will be selected and will act on the 14 Case
Can I name the 14 Case as one and not have to end up with a mile long code?
Example:

Select Case Grade
        Case Is >= 90
            LetterGrade = "A"
        Case Is >= 80
            LetterGrade = "B"
        Case Is >= 70
            LetterGrade = "C"
        Case Is >= 60
            LetterGrade = "D"

       etc...etc...
        Case Else
            LetterGrade = "Sorry"
    End Select

would become:

Select Case test
    End Select

 

[ndendrinos]

Sorry but I just revisited this posting to try and understand why the code would paste to J101 and saw your last remark that works very well indeed.
Thank you again