Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, is ther a better way of writing this.
If r = "K" And i = 2 Or r = "Q" And i = 2 Or r = "J" And i = 2 Then r1 = 10 + i y = i x = 112 end if. As you can see i always = 2 but r can be a k,q, or j. This way works perfect, just thinking that there may be a better way. I was thinking something like if r = k/q/j. regards Robert |