- Sub Macro8()
- '
- ' 宏由 h 记录,日期: 2023/2/28
- ActiveSheet.Shapes.AddLine(240, 100, 360, 100).Select
- ActiveSheet.Shapes.AddLine(225, 120, 345, 120).Select
- ActiveSheet.Shapes.AddLine(210, 140, 330, 140).Select
-
- ActiveSheet.Shapes.AddLine(195, 160, 315, 160).Select
- ActiveSheet.Shapes.AddLine(195, 200, 315, 200).Select
- ActiveSheet.Shapes.AddLine(195, 240, 315, 240).Select
- ActiveSheet.Shapes.AddLine(195, 280, 315, 280).Select
-
- ActiveSheet.Shapes.AddLine(195, 160, 195, 280).Select
- ActiveSheet.Shapes.AddLine(235, 160, 235, 280).Select
- ActiveSheet.Shapes.AddLine(275, 160, 275, 280).Select
- ActiveSheet.Shapes.AddLine(315, 160, 315, 280).Select
-
- ActiveSheet.Shapes.AddLine(330, 140, 330, 260).Select
- ActiveSheet.Shapes.AddLine(345, 120, 345, 240).Select
- ActiveSheet.Shapes.AddLine(360#, 100, 360#, 220).Select
-
- ActiveSheet.Shapes.AddLine(195, 100, 240, 160).Select
- ActiveWindow.Selection.ShapeRange.Flip msoFlipVertical
-
- ActiveSheet.Shapes.AddLine(235, 100, 280#, 160).Select
- ActiveWindow.Selection.ShapeRange.Flip msoFlipVertical
-
- ActiveSheet.Shapes.AddLine(275, 100, 320, 160).Select
- ActiveWindow.Selection.ShapeRange.Flip msoFlipVertical
-
- ActiveSheet.Shapes.AddLine(315, 100, 360, 160).Select '
- ActiveWindow.Selection.ShapeRange.Flip msoFlipVertical
-
- ActiveSheet.Shapes.AddLine(315, 140, 360#, 200).Select
- ActiveWindow.Selection.ShapeRange.Flip msoFlipVertical
- ActiveSheet.Shapes.AddLine(315, 185#, 360#, 240).Select
- ActiveWindow.Selection.ShapeRange.Flip msoFlipVertical
- ActiveSheet.Shapes.AddLine(315, 219#, 360#, 280).Select
- ActiveWindow.Selection.ShapeRange.Flip msoFlipVertical
- End Sub
复制代码
麻烦各位老师修改下,谢谢。 |