本帖最后由 lingyuncelia1 于 2016-2-23 12:02 编辑
lichuanboy44 发表于 2016-2-23 11:09
如果57只出现2次,则标示为36号字体,在A1:I1出现1次或3次则不标示,如果是这个 意思,代码如下:另外, ...
谢谢您的宝贵意见,我的确是这个意思.如果变成如下代码是可以的:
Sub c() Sheet2.Range("A1:I1").FormulaR1C1 = "=TEXT(sheet1!RC,0)" Sheet2.Range("A1:I1").Copy Sheet1.Range("A1:I1").PasteSpecial Paste:=xlPasteValues Sheet2.Range("A1:I1").Clear Sheet1.Activate a = 5 b = 7 mycount = Application.WorksheetFunction.CountIf(Range("a1:i1"), "*" & "5" & "*" & "7" & "*") For k = 1 To 9 If mycount = 2 And Cells(1, k).Text Like "*" & "5" & "*" & "7" & "*" Then Cells(1, k).Font.Size = 36: Cells(1, k) = a & b Next End Sub
但我改写成以下代码又不成功了
Sub 隐含唯2数法()
'数字变文本
Sheet2.Range("A1:I1").FormulaR1C1 = "=TEXT(sheet1!RC,0)"
Sheet2.Range("A1:I1").Copy
Sheet1.Range("A1:I1").PasteSpecial Paste:=xlPasteValues
Sheet2.Range("A1:I1").Clear
Sheet1.Activate
For j = 1 To 9
For a = 1 To 8
For b = a + 1 To 9
mycount = Application.WorksheetFunction.CountIf(Range("a1:i1"), "*" & a & "*" & "b" & "*")
next
next
If mycount = 2 And Cells(1, j).Value Like "*" & a & "*" & "b" & "*" Then
Cells(1, j).Font.Size = 36
Cells(1, j) = a & b
end if
Next
End Sub
难道要用肉眼找数字5与7? |