|
- Sub Macro1()
- For Each c In ActiveSheet.Shapes
- If c.Type <> 8 Then c.Delete
- Next
- For i = 17 To Range("g65536").End(xlUp).Row
- n = Val(Replace(Cells(i, "g"), "±", ""))
- For j = 8 To 17
- If Abs(Cells(i, j)) > n Then
- Set rng = Cells(i, j)
- x = rng.Left + rng.Width * 0.1
- y = rng.Top + rng.Height * 0.1
- w = rng.Width * 0.8
- h = rng.Height * 0.8
- ActiveSheet.Shapes.AddShape(msoShapeIsoscelesTriangle, x, y, w, h).Select
- Selection.ShapeRange.Fill.Transparency = 0.7
- End If
- Next
- Next
- End Sub
复制代码 |
|