請教excel VBA高手 作用範圍:A1:AV1000 判斷欄：K欄 如K2欄開頭以"ABC-"出現 則第2列整列使用綠色mark(即A2:AV2使用綠色mark) 如K7欄開頭以"ABC-"出現 則第7列整列使用綠色mark(即A7:AV7使用綠色mark) 否則不做任何動作?
回答 (2)
2017-07-22 3:53 pm
2017-07-22 10:28 pm
Cells.Interior.ColorIndex = xlNone
For i = 1 To 1000
Cx = Cells(i, 11)
Rng = "ABC-" & "*"
If Cx Like Rng Then
Range("A" & i & ":AV" & i).Interior.ColorIndex = 50
Range("A" & i).Select
End If
Next
For i = 1 To 1000
Cx = Cells(i, 11)
Rng = "ABC-" & "*"
If Cx Like Rng Then
Range("A" & i & ":AV" & i).Interior.ColorIndex = 50
Range("A" & i).Select
End If
Next
收錄日期: 2021-05-03 06:47:32
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20170722053338AAaODTI