Select Case syntax
Hi Susan,
Try changing each instance of Cells to Range.
The correct syntax for cells is:
Cells(RowNo, ColNo) or Cells(RowNo, "ColLetter")
---
Regards,
Norman
"Susan Hayes" wrote in message
...
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
|