|
楼主 |
发表于 2009-12-21 16:54
|
显示全部楼层
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
Sub zf()
'On Error Resume Next
Dim i%
Dim MR As Range
Set MR = Sheet3.Range("a150:F232")
'If Not IsEmpty(MR) Then
MR.Select
ML = MR.Left
MT = MR.Top
MW = MR.Width
MH = MR.Height
ActiveSheet.Shapes.AddShape(msoShapeRectangle, ML, MT, MW, MH).Select
ActiveSheet.Paste
'MR.PasteSpecial Paste:=xlPasteAll
', Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
End Sub
形状定位
ActiveSheet.Shapes.AddShape(msoShapeRectangle, ML, MT, MW, MH).Select
ActiveSheet.Paste可以定位到range,但形状不对. |
|