圖一
Sub printgif()
ActiveWindow.Zoom = 100
Range("A1").Select
Dim rngCopy As Range
Set rngCopy = Sheet1.Range("A1:C5")
rngCopy.CopyPicture Format:=xlBitmap
With ActiveSheet.ChartObjects.Add(, , rngCopy.Width, rngCopy.Height).Chart
.Paste
.Export Filename:="" & Sheet2.Range("A1") & "", FilterName:="GIF"
.Parent.Delete
End With
ActiveWindow.Zoom = 75
End Sub作者: rouber590324 時間: 2022-8-16 13:35
DEAR ALL 大大
經研究
With ActiveSheet.ChartObjects.Add(, , rngCopy.Width, rngCopy.Height).Chart
加上0,0,…就可以了
With ActiveSheet.ChartObjects.Add(0,0 , rngCopy.Width, rngCopy.Height).Chart
看來2010以上版本不支援空白引數
THANKS*10000