View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
susan hayes susan hayes is offline
external usenet poster
 
Posts: 31
Default Select Case syntax

I have entered the following where if cell K17 = United Kingdom and
if cell K16 = USD then cell B75 = cell U13 . . . .
However when I run it the debug window pops up.
Is this due to the syntax being incorrect?

Select Case Range("K17").Value
Case "United Kingdom":
If Range("K16").Value = "USD" Then
Cells("B75").Value = Cells("U13").Value
ElseIf Cells("K16").Value = "CAD" Then
Cells("B75").Value = Cells("S13").Value
End If
Case Else:
Cells(75, "B") = ""
End Select

Thank you in advance Susan