2,462
社区成员
发帖
与我相关
我的任务
分享
Sub exportPic()
Dim K As Long
For K = 1 To Cells(Rows.Count, 1).End(xlUp).Row
Sheets(1).Cells(K, 1).CopyPicture
Dim CHT As Chart
Set CHT = ActiveSheet.ChartObjects.Add(0, 0, Cells(K, 1).Width, Cells(K, 1).Height).Chart
With CHT
.Paste
DoEvents
.Export "d:\" & Cells(K, 1) & ".JPG"
.Parent.Delete
End With
Next K
Set CHT = Nothing
End Sub