很简单的一个VBA如下,但是有个同事用Mac,google说要转成applescript。哪个同学
能不能告诉我怎样转阿?
包子谢!!
Sub PrinterAddress()
Worksheets(" PO ").Activate
Range("B9").Select
If Range("B9").Value = "A" Then
Range("B10").Value = "A"
Range("B11").Value = "A"
Range("B12").Value = "A"
Range("B13").Value = "A"
Range("B14").Value = "A"
Else
If Range("B9").Value = "B" Then
Range("B10").Value = "B"
Range("B11").Value = "B"
Range("B12").Value = "B "
Range("B13").Value = "B"
Range("B14").Value = "B"
Else
MsgBox "Wrong Vendor Name"
end if
End I