با سلام
فایل پیوست را بررسی و اعلام نظر بفرمایید
کد PHP:
Sub GetNumbers()
Dim xValue As String
Dim OutValue As String
Dim I, J As Long
Dim sht As Worksheet
Dim WS As Worksheet
Macro1
Set sht = ThisWorkbook.Worksheets("SHEET1")
X = sht.Cells(sht.Rows.Count, "A").End(xlUp).Row
For J = 3 To X
OutValue = ""
xx = Range("c" & J).Value
yy = Range("a" & J).Value
ZZ = InStr(yy, xx) + Len(xx)
xValue = Range("a" & J).Value
For I = 1 To ZZ
If VBA.IsNumeric(VBA.Mid(xValue, I, 1)) Then
OutValue = OutValue & VBA.Mid(xValue, I, 1)
End If
Next
If OutValue <> Range("c" & J).Value Then
Range("c" & J).Interior.ColorIndex = 3
End If
If Range("B" & J).Value <> Range("D" & J).Value Then
Range("B" & J).Interior.ColorIndex = 3
End If
Next
End Sub
علاقه مندی ها (Bookmarks)